Forum Discussion
Measure vs Calculation
I am using Power BI Desktop to develop a model. It has a table named Sales, which includes a column named CustomerKey. In reports, I need a calculation to show the number of different customers who have placed orders. What type of DAX calculation will I add to the Sales table?
- measure
- calculated column
- computed column
- calculated table
And what's the difference between them ?
amirabedhiafi , In this case it will be measure. Sum(Sales[Sales Amount])
refer these
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-calculated-tables
1 Reply
amirabedhiafi , In this case it will be measure. Sum(Sales[Sales Amount])
refer these
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-calculated-tables