Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
iceteapilot
Helper I
Helper I

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.
Untitled.png
 
 
1 ACCEPTED SOLUTION

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@iceteapilot 

Are you using all in the formula of [TotalSales]. Share formula of [TotalSales]

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.