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.
I discovered that it is not possible to remove any of the suppliers in the report level filter, any ideas to why? The screenshot explains the error.
It is possible to selct only one supplier in the report level filter, but if I deselect one supplier the pareto formula crashes. Unfortunately the formula is too advanced for me to pinpoint where the error lies, and the Power BI error message does not help much..
Were you ever able to figure out the issue with multiple values provided but a single value expected? I am running into a similar issue where if the field I'm aggregating (customer name in may case, instead of supplier name) is filtered, the error is shown. It seems like it has to be all items in the table. Even creating just a portion of the formula in the dummy pbix file results in the error.