Rank on card not displaying card correctly

[Anonymous]

Hi,

I have a sales rank measure for stores (site) which can be filtered by the brand of our store. 

Sales Rank = RANKX(all('PowerBI Store Sales Data'[Site]),CALCULATE(sum('PowerBI Store Sales Data'[SALE_VALUE])))

The measure works fine when all the sites are in a table. But when I apply the measure to a card with a single selection slicer for the site the rank is not displaying correctly. Any idea why this may be? (lines repsent an active slicer)

[parry2k · Accepted solution]

@Anonymous yes site, sorry. can you try a visual with site, rank and value, and filter it on 0001, don't filter it on brand

[parry2k]

@Anonymous I'm sure same size is used across multiple brands, if you put a table with size and rank,and filter that table for size in this example 0001,you will rank 2 for Brand = TS and Size = 0001.

[Anonymous]

Hi,

sorry, do you mean site rather than size? Brand TS and Site 0001 is the largest site regardless of brand. (as dispalyed by bottom right table)

[parry2k · Accepted solution]

@Anonymous yes site, sorry. can you try a visual with site, rank and value, and filter it on 0001, don't filter it on brand

[Anonymous · Accepted solution]

Ah it's ok. I had a page level filter applied to the card filtering for transaction type I wasn't aware of. 

Thanks anyway

[parry2k]

@Anonymous sounds good.