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 C...
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.

     

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.