Forum Discussion
Solved
Warning when Market Share falls below
Please see Sample Data through this link Hi All I have a matrix where it displays my clients and how much they have purchased with us as well as with competitors. The challenge that I have...
Rather than use % Row total you need to write a few measures.
Revenue = SUM(Dashboard[Base Amount]) Share = CALCULATE([Revenue],Dashboard[Bought_from_us_or_Competitor]="ABC CO") / [Revenue]
With these measures and using [Share] in your visual you can sort by Market Share and put the lowest on top. See link
Rather than use % Row total you need to write a few measures.
Revenue = SUM(Dashboard[Base Amount]) Share = CALCULATE([Revenue],Dashboard[Bought_from_us_or_Competitor]="ABC CO") / [Revenue]
With these measures and using [Share] in your visual you can sort by Market Share and put the lowest on top. See link
Seward12533 this is perfect, I added this Share Measure into the filter and applied the amounts I wanted to see. Thank you very much for this