This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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 ?
Solved! Go to Solution.
@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
@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
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 32 | |
| 25 | |
| 24 | |
| 22 | |
| 13 |
| User | Count |
|---|---|
| 61 | |
| 47 | |
| 27 | |
| 24 | |
| 19 |