IF condition but need to show total

[Anonymous]

Hello Everyone,

I have this condition that only if the result is negative then it would show else it would show blank. Problem is, it would no longer show the total. Would you know the reason why and do you have another way of writing this DAX to show the total?

Saving (USD) = IF(([Variance] * CALCULATE(SUM(Salary[Salary in USD]),TREATAS(DISTINCT(Table1[Delivery Country]),Salary[Country]))) >0,"",([Variance] * CALCULATE(SUM(Salary[Salary in USD]),TREATAS(DISTINCT(Table1[Delivery Country]),Salary[Country]))))

Thank you!

Here's a screenshot of the table

[amitchandak · Accepted solution]

@Anonymous , Based on the group by in yourr visual, you need to create a measure

sumx(Values(Table1[Delivery Country]),[Saving (USD)])

and use that.

Also, check

https://www.youtube.com/watch?v=ufHOOLdi_jk