Trying to get the total sum correct based on previous given condition

[AleGuty04]

Hi All!

I'm pretty new to DAX code and to Power BI in general, I'm facing an issue right now where I can't get the total sum correct based on previous given condition:

Basically what I'm trying to do is to get only the IF Fines if the are above the 98% column (IF%) but instead I'm getting the total sum as it was ignoring my previous condition as you can see in above picture, here's the formula:

IF Fines DAX = if([IF %] > .98, 0,

CALCULATE(

[Sum of if fines],

ALLEXCEPT(' Date', 'Date'[Month Year])))

I tried some work-arounds but without any luck, does anyone know how I can get the correct total sum for the IF Fines column?

Also, this is a DirectQuery Model so take that in mind as I'm limited to create calculated columns

[DataInsights · Accepted solution]

@AleGuty04,

Try this measure:

IF Fines DAX =
SUMX (
    VALUES ( YourTableName[customer_vendor_num] ),
    IF ( [IF %] <= .98, [Sum of if fines] )
)

Here's an article on totals:

https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/ 

[AleGuty04]

This is exactly what I needed, thank you so much!