Forum Discussion
NaveenMD
Helper I
Helper IRanking each cell in column from conditional formatting
What I am trying to achieved is column value based conditional formatting ie. if my value in cell 1 > value in cell 2 then cell 1 should be in darker shade. I believe this can be easily implemen...
Daniel29195
Community Champion
Community Championuse
rankx and allselected() function .
measure_sales amount =
sales amount = sum(tbl_name[col_name])
measure rank =
rankx ( allselected ( tbl_name[col_name] ) , [sales amount] , asc )
hope this helps .
NB : the idea is to use allselected () so that the rankx act according to your filters .
change the tbl_name and col_name with your appropriate names from your model .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
NaveenMDHelper I
Helper Itried this all values become 1
- Daniel29195
did you use allselected on the colummn having the values A,B,C,D ... ?