I am trying to build a visualization, creating a calculated measure using the Percentage Of function, as showed in the picture below.
Note the aggregation total number. When I add a top 3 Rank filter, as stated below, the aggregation total changes, and so the Percentage of.
I want to show a market share table, filtering only the top vendors, and their respective share. This way, I cannot add any rank filter.
Is there any way to make this happen?