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

Icey's avatar
Icey
Community Support
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.