Forum Discussion
display Rank on a Card visualization
- 9 years ago
Hi wilson_smyth,
I don't know how you are calculating your ranking but I ussually use one specific column to rank the values that I need to filter/slice them and them I can use it to have my ranking.
I have created a simple table with Store and Sales then added two measures:
NORMAL_RANK = RANKX( ALLSELECTED(Sales[Store]); CALCULATE( SUM(Sales[Sales]) ) )
This first measure interacts with the slicers/filter I introduce in the report so it's dinamic and my rank will be influenced by taking out stores from my visual or adding them
OVERALL_RANK = RANKX( ALL(Sales[Store]); CALCULATE( SUM(Sales[Sales]) ) )
In this measure using the ALL function no matter how I have my data sliced it will give me the complete ranking of the store so you can use it in your cards see print below. However using this one if you select more than one value in your slicer in your cards it will give you the first value so be aware of that limitation.
Regards,
MFelix
- 9 years ago
Apologies, should have responded sooner.
Yes, I found a solution, its pretty much what MFelix suggested.
I was trying to use one calcuation to do two things:- show the rankof all stores
- show just the rank of the selected score on a card.
The problem was that if i got a calculation to show the list rank, it always displayed a value of 1 when placed on a card, and if i got the correct calculation to show the rank on a card, it wouldnt show the ranked list. so 2 calculations were created.
Store Ranking Table = RANKX(ALL('Table'[Store]), CALCULATE([Score]),,0,Dense)
Individual Store Rank = RANKX(ALL('Table'[Store]), CALCULATE([Score], ALLSELECTED('Table'[Store])),,0,Dense)
Hi wilson_smyth,
I don't know how you are calculating your ranking but I ussually use one specific column to rank the values that I need to filter/slice them and them I can use it to have my ranking.
I have created a simple table with Store and Sales then added two measures:
NORMAL_RANK = RANKX( ALLSELECTED(Sales[Store]); CALCULATE( SUM(Sales[Sales]) ) )
This first measure interacts with the slicers/filter I introduce in the report so it's dinamic and my rank will be influenced by taking out stores from my visual or adding them
OVERALL_RANK = RANKX( ALL(Sales[Store]); CALCULATE( SUM(Sales[Sales]) ) )
In this measure using the ALL function no matter how I have my data sliced it will give me the complete ranking of the store so you can use it in your cards see print below. However using this one if you select more than one value in your slicer in your cards it will give you the first value so be aware of that limitation.
Regards,
MFelix
- Anonymous4 years agoNot applicablethanks.RANKX(ALL(DimProvider),[ActualValue_CRM] )the above dax formula works fine, but i need the order of the rank to be ASC.[ActualValue_CRM] is a measure.
- MFelix4 years agoSuper User
Hi Anonymous ,
The 4rd parameter of the RANKX is the order you just need to do your measure like this:
RANKX(ALL(DimProvider),[ActualValue_CRM],, ASC )- Anonymous4 years agoNot applicable
Thanks , The Rank start with 2, and i don't want to use allselected because i will use card visual, any solution?
much appreciated
- nardtmo2 years agoHelper III
Hi Mfelix,
Thanks in advance. Having issue with ranking ranking starting with 2 after adding row (region). i tried adding isinscope in the formula but ranking is still wrong. thanks
output: ranking of market selected inside a card in nation and northeast
example NY rank 8 in nation & in NE rank in 5
RANK =if(isinscope(data3[MARKET]),RANKX (ALLSELECTED(data3[MARKET]),[round_values], , ASC, Dense))overall_rank = RANKX(All(data3[MARKET]),[round_values], ,ASC, Dense)my data:MARKET Sum of 7Days_Rolling_sale_Per_Market REGION Las Vegas 0.3855 WEST Albuquerque 0.3692 WEST Hawaii 0.3565 WEST San Francisco 0.3452 WEST San Diego 0.3434 WEST Los Angeles 0.3341 WEST LA North 0.3305 WEST Southern California 0.3268 WEST Long Island 0.2753 NORTHEAST Orlando 0.2701 SOUTH Salt Lake City 0.2629 WEST Washington DC 0.2627 NORTHEAST Sacramento 0.2614 WEST New York 0.2575 NORTHEAST Upstate NY 0.2453 NORTHEAST New Jersey 0.2407 NORTHEAST Miami 0.239 SOUTH New England 0.238 NORTHEAST Philadelphia 0.2358 NORTHEAST Virginia 0.2356 NORTHEAST Connecticut 0.2329 NORTHEAST Jacksonville 0.2176 SOUTH Tampa 0.2132 SOUTH South Carolina 0.2104 NORTHEAST North Carolina 0.2069 NORTHEAST Central PA 0.1933 NORTHEAST