Calculate Measure - Total is Incorrect

[emiec]

I am using the following DAX expression to calculate the difference between Minutes Used and (Ad-hoc + Baseline).  It works.

However, when I look at it in table format, image below, the ExcessUsage TOTAL = 863,397,953; which is incorrect.  It should be 54,733,805.  Any suggestions on why this is happening?

ExcessUsage =

IF

(

(MAX(Statistics[AssignedMinutes]) - (Reporting[Ad-HocUsage] + Reporting[BaselineUsage]) < 0),

CALCULATE

(

MAX(Statistics[AssignedMinutes]) - (Reporting[Ad-HocUsage] + Reporting[BaselineUsage]),

FILTER

(

Reporting,

SUM(Reporting[Minutes_Used]) > MAX(Statistics[AssignedTokenMinutes])

)

),

BLANK()

)

[Anonymous]

Hi @emiec 

Can you please post the raw datasets and pbix in google drive / onedrive and shre the link here to formulate a solution.

Cheers

CheenuSing

[Anonymous · Accepted solution]

Try wrapping your function in SUMX:

SUMX( 
   VALUES( Table [ Column] ),
....

[emiec]

I ended up writing the following DAX measure and it worked.  Thanks for the suggestion.

EU = SUMX(SUMMARIZE(VALUES(Reporting),Reporting[JobEndTime]),[MinutesUsed] - [Base Usage])

[emiec]

Thanks for the suggestion.  I did try but it didn't work.