What is measure in Power BI DAX ?. What is Fact and What is dimension ?

Measure:


Measure is a "Calculated Field" in Power BI DAX.

Example: Total Sales, Total Salaries, Average Quantity and so on.

To create a calculated field, you must use the data which is Fact. Because the data which is Fact allows calculations on the data.

Fact:


Fact is numerical data which will allow calculations such as sum, avg, max and so on.

Example: Sales, Salaries, Quantity and so on.

Dimension:


Dimension is non-numerical data which will NOT allow calculations such as Name, Day, Country and so on.

Example: Name, Day, Country and so on.

To know about Power BI DAX in detail Click Here

POWER BI INTERVIEW QUESTIONS - INDEX

Functions in Power BI dashboards


What is the default visual interaction in Power BI ?
How to change default visual settings in Power BI ?
How many types of interactions are there in Power BI ?.


What is DAX in Power BI ?
How to implement DAX in Power BI ?
What are the most commonly used DAX functions in Power BI ?
Sample DAX Formula in Power BI.


Explain Power BI Data Refresh Architecture


Configuring automatic refresh in Power BI


What is Differences between visual level filters, page level filters and report level filters in Power BI


What is Difference between Power BI Desktop and Power BI


Building Blocks in Power BI (or) Components of Power BI.


Difference between Microsoft Business Intelligence MSBI and Power BI. SSIS, SSAS and SSRS.