Forum Discussion
Top N Percent Matrix Visual
RLSid17 , for TOP you can try TOPN function
example
CALCULATE([Net], TOPN(3,ALLSELECTED('Item'[Category]), [Net],DESC), values('Item'[Category]))
TOPN: https://youtu.be/QIVEFp-QiOk
For Top % , Try like
I tried Top N but it doesn't show the results I'm expecting and I'm not sure if the Pareto Analysis would fit in.
Basically, the requirement would be like this, this is the visual I have:
And they would like for it to be like this in a separate visual (I know it may seem that I have already done it but this is only filtered, they would want for it to automatically get the percentage from the 1st visual:So for example, all 3 above only has Favorable responses. They would also want it to get Unfavorable responses. So basically if 2 out of 3 column rows are blank, that would only get the value.
Please let me know if this would be possible and if there are any queries needed on my end.
