Fixed ranking and how to automatically update cards

[hidenseek9]

Hello Power BI Community,

I would like to have a customer report where it shows a list of growing customers 

and when I select a particular customer from the list, 

the cards will show 

1. TTL Sales of the customer
2. TTL Sales of all customers
3. The ranking of the customer in respect to all customers
4. # of TTL customers
5. The ranking of cutomers in respect to the customer channel
6. # of TTL customers in a particular Channel
7. TTL Sales of all customers in the particular channel

Please find below as a sample data and the image of how I would like to data to look like. 

Please also keep in mind that TTL Sales in Power BI I already set it up as a measure. 

Sample Data 

When I select "Bison", I would like the text in the card will automatically 

say "Bison Sales" or "Bison Ranking in Meat". 

If you could help me, that would be much appreicated

Many thanks,

H

[Anonymous]

@hidenseek9 Please use below measures

SelectedStoreSales = CONCATENATE(CONCATENATE(SELECTEDVALUE('Table'[Store])," Sales")&UNICHAR(10),SUM('Table'[Sales]))

Define rank of stores

Rank = RANKX(FILTER(ALL('Table'[Channel],'Table'[Store]),'Table'[Channel]=MAX('Table'[Channel])),CALCULATE(SUM('Table'[Sales])))

Finally rank of store sales in a channel

Measure 2 = CONCATENATE(SELECTEDVALUE('Table'[Store])&" Ranking in "&SELECTEDVALUE('Table'[Channel])&UNICHAR(10),[Rank])

[hidenseek9]

@Anonymous 

Thank you for your quick reply!

The measure to show the ranking among the channel works perfectly.

However, I cannot seem to figure out how to create a similar measure to show

the ranking among all the customers.

Also, while the concatenate measure works, it does not give me the option of showing the values in

thousands, millions or billions and the number is just a string of numbers and difficult to read.

Is there any other way (Does not have to be cards) to

1. shows sales as figures (to have the option to show it in TH, M or Billions)

2. Have the description of the text to change depending on the selection of a customer

Many thanks,

H

[v-frfei-msft · Accepted solution]

Hi @hidenseek9 ,

Here I have created  a sample for your reference.We can create measures as below to work on it.

SALE = CALCULATE(SUM('Table'[Sales]))

RANK in TTL sotres = RANKX(ALL('Table'[Store],'Table'[Channel]),[SALE],,DESC,Dense)

Ranking in = RANKX(ALL('Table'[Store]),[SALE],,DESC,Dense)

Total sales # = var cha = MAX('Table'[Channel])
return
CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),'Table'[Channel] = cha))

TTL # of stores = CALCULATE(DISTINCTCOUNT('Table'[Store]),ALL('Table'))

TTL Sales = CALCULATE(SUM('Table'[Sales]),ALL('Table'))

Btw, for your first requirement, we cannot achieve that automaticly. Currently, we can edit it in format pane.

For the second one, we can make the tile name conditional formatting by column name to work around.

For more details, please check the pbix as attached.