Forum Discussion

iceteapilot's avatar
iceteapilot
Icon for Helper I rankHelper I
6 years ago
Solved

SUM 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.
 
 
  • iceteapilot's avatar
    iceteapilot
    6 years ago

    Pls close the topic, i have fixed it by using Quick Measure option.

2 Replies

    • iceteapilot's avatar
      iceteapilot
      Icon for Helper I rankHelper I

      Pls close the topic, i have fixed it by using Quick Measure option.