Forum Discussion

Brite's avatar
Brite
Helper I
4 years ago
Solved

Power Bi DAX Measure Adding Wrong Help

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)
Need Help
Tutorial Requests
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    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.

     

2 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    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.