Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Counting Percentages

Hi everyone,

 

I have a calculated measure, where a calculate the percentage of the products we have in the inventory, and we have a target of 98.5% of accuracy of the inventory.

What I need to do is to count how many products did not meet the target of 98.5%, also for how much the missed the target. For example three products didnt meet the target by 1% because they reached 97.5%, 10 products didnt meet the target bt 3% because they reached 95.5%.

 

It sounds confusing but I dont know a better way to explain.

 

Thank you in advance.

Need Help
  • Icey's avatar
    Icey
    4 years ago

    Hi Anonymous ,

     

    Can this meet your requirements?

     

    Steps:

    1. Create Bins.

     

    2. Create measures.

    Diff = MAX('Table'[accuracy (bins)])-0.985
    Counts_<Target (Optional) = CALCULATE(DISTINCTCOUNT('Table'[Product]),'Table'[accuracy]<0.985)

     

     

    Best Regards,

    Icey

     

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

2 Replies