DAX Measure is blank on card

[Anonymous]

Hello DAX Masters,

I'm calculating the "BonusCommission" earned if some accounts hit a certain goal, I'm able to generate this value at a matrix without issues.

I think the problem is that my "Bonus Comm Payout" calculation depends on an if statement where a "% to Goal" has to be above 100%

Bonus Comm Payout* = 

VAR QualifyingRevenue = CALCULATE( SUM( Sl_Booking[GTR USD]))

RETURN 

IF( [% to Goal] >= 1 , QualifyingRevenue * [Bonus Comm %] , 0)

My expected result should be 464.26 + 208.12 = 672.38

Any guidance is greatly appreciated!

[MattAllington]

The issue is that your matrix is providing some filter that is not being provided by your card. I can't tell from the image what that filter is, but you need to replicate that filter in your measure using a SUMX. You can read my longer explanation in my blog article explaining sum vs sumx

Bonus Comm Payout* = 

sumx(values(table[column filtering your matrix]),IF( [% to Goal] >= 1 , CALCULATE( SUM( Sl_Booking[GTR USD])) * [Bonus Comm %] , 0))