RANKX not working with Filters on Visual

[apantovic]

Hi all,

I'm building dashboard and I'd like to display the rank of the brand based on its market share.

The data looks like:

Category	Brand	Value
C1	B1	10
C1	B2	5
C1	B3	1
C2	B1	50
C2	B2	10

Market share is calculated based on the Value column, and I'd have separate table for each category where filter on the each visual (table) would be different category.

I have a measure to calculate brand share but when I throw it in the RANKX function it returns me all the same values:

BrandRank = RANKX(ALLSELECTED('Data'), [BrandShare],,DESC, Dense)

I've also tried different variations like RANKX('Data', [BrandShare],,DESC, Dense) etc but I'm not sure what am I missing and why it's not working as expected. 

[Ashish_Mathur]

Hi,

These measures work

V = SUM(Data[Value])

MS = DIVIDE([V],CALCULATE([V],ALL(Data[Brand])))

Rank = RANKX(ALL(Data[Brand]),[MS],,DESC)

Hope this helps.

[sergej_og]

Hey @apantovic ,
something like this?

with applied filter:

Regards