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