Forum Discussion
Creating cumulative measure based on dynamic ranking / Dynamic running total/pareto diagram-measure
Hi, try reviewing this blog's post.
Is in spanish but i hope can help you.
Regards
Victor
Lima - Peru
Hi,
You may refer to my solution in this workbook. There is one problem that when i select 2015 in the slicer, i get the result for "B" as 2 whereas it should be 3. I cannot figure out why that is happening. Hope someone else can pitch in.
Thanks for the reply and solution.
A little tweak of the formula seems to solve the problem, I guess it has something to do with the && logic in countrows.
Changing the measure for B to this solved the issue for me:
B - 80-95% of spend = COUNTROWS(FILTER(VALUES(Sheet1[SupplierName]);[Accumulated spend per supplier]/[Total spend]<=0,95))-[A - 80% of spend]
However, why is it not possible to select and slice the data by choosing for example the A category and get the other visuals updated?
Thanks
/André
Super UserHi,
The A,B and C categories are the result of a measure. Had they been values lying in a column, then you would have been able to slice and dice by clicking.
Hi Ashish_Mathur,
Thanks for the reply!
Is there no way of making the slice and dice option available?
- Ashish_Mathur
Hi,
I don't think so. Not as long as A,B and C are measures.