Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Total value is going less when filter is not applied

I am calculating total NCA PPM by using total received from NCA table and the Quantity received from Difot table. The total NCA PPM is correct or more when it is filtered by month, but less when it i...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi Anonymous ,

     

    In the Total part, the formula calculates (the total value of NCA[QTY Rejected]) / (the total value of Difot[Quantity Recieved]) in the selected range, so there may be some months's value greater than the value when it is not filtered.

     

    The following is my sample data, and my measure is:

    NCA PPM = 
DIVIDE(
    SUMX(NCA, NCA[QTY Rejected]),
    SUMX(RELATEDTABLE(Difot), Difot[Quantity Recieved])
)

    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
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

In the Total part, the formula calculates (the total value of NCA[QTY Rejected]) / (the total value of Difot[Quantity Recieved]) in the selected range, so there may be some months's value greater than the value when it is not filtered.

 

The following is my sample data, and my measure is:

NCA PPM = 
DIVIDE(
    SUMX(NCA, NCA[QTY Rejected]),
    SUMX(RELATEDTABLE(Difot), Difot[Quantity Recieved])
)

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.