Forum Discussion

Stevianne's avatar
Stevianne
Frequent Visitor
4 years ago

ABC Pareto analysis

Hi All,

 

I made a Pareto / ABC analysis in Powerbi. How can I calculate how many product do have an A status? 

I want to put the result in a card. 

 

 

 

 

Need Help

5 Replies

  • rsbin's avatar
    rsbin
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Stevianne ,

    Try a Measure like:

    NewMeasure = CALCULATE( COUNTROWS(YourTable), FILTER(YourTable, YourTable[ABC] = "A" ))

    Then use this measure in your card visual.

    Hope 

    • Stevianne's avatar
      Stevianne
      Frequent Visitor
      4 years ago

      Hi,

       

      I already created an ABC/Pareto measure. ABC analysis is based on a measure not on an excisting table. Based on a filter this ABC analysis changes when I change the filter so you can call it a dynamic ABC analysis.

       

      Based on this measure I want to know how many product do have an A status.

       

       

      • rsbin's avatar
        rsbin
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Stevianne ,

        Sorry that response doesn't work for you.  Getting a "count of a measure" seems a little more complex and I can't help you directly.  However, if you search the Board for this term, hope you will get a result that you can use.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Stevianne ,

     

    According to your description, you want to add a filter condition on top of the number of statistics A, right? You may want to create the following measure and put it in Filter on this visual

    Measure = 
var a = SELECTEDVALUE('Table'[slicer_field])
return
IF(MAX('Table'[slicer_field])=a,1,0)


    If the problem is still not resolved, please point it out and let me know immediately. Looking forward to your feedback.


    Best Regards,
    Henry


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