Forum Discussion
iceteapilot
Helper I
6 years agoSUM with a condition
Hi, I checked multiple posts but have not been able to arrive at the correct formula.
I have a table (sales of vehicles over last 10 years) with a Sales column. I have created a measure called TotalSales.
Now, in the table, i have another column which classifies the car types as either Mainstream or Premium.
I created following DAX formula:
TotalMainstream = CALCULATE([TotalSales],'SalesData-UAE'[TYPE]="Mainstream") -> this just gave me TotalSales Again
Tried couple of variations of SUMX as well, did not seem to work.
Attaching the screenshot.. pls let me know.
Pls close the topic, i have fixed it by using Quick Measure option.
2 Replies
- amitchandak
Super User
Are you using all in the formula of [TotalSales]. Share formula of [TotalSales]
- iceteapilot
Helper I
Pls close the topic, i have fixed it by using Quick Measure option.