Power Bi DAX Measure Adding Wrong Help

[Brite]

Hi everyone,

I am stuck on this measure adding the total wrong and am unsure why. 

The DAX formula I am using: 

Month1_Reject Rate FINAL = IF([Total_Rejected]<2,(calculate([Pay1],'Fail Cancel.Rejected'[ STRIPE_ID]<>Blank())), 0)

[v-kkf-msft · Accepted solution]

Hi @Brite ,

In the total section [Total_Rejected] = 84 > 2, then the measure [Month1_Reject Rate FINAL] returns 0. If you want to sum the measure [Month1_Reject Rate FINAL] in the total section, you can try the following formula:

Total = 
If(
  ISFILTERED(Table[column]),
  [Month1_Reject Rate FINAL],
  sumx( allselect(Table[column]), [Month1_Reject Rate FINAL] )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

Please see this video for how to get the expected total.

(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube

Pat