Forum Discussion
color coding change on selection
i am working on a report that shows customer purchases on each product the idea is the create a color coding as per the following: top transactions, mid transactions, and low transactions. i alreay...
ChahindaAlyy whatever logic yu are using to calculate the color coding, you need to change that DAX measure to include ALL customers, not the selected one, so measure should have ALL function.
Hi parry2k
my Formulas are as follow:
i am creating a formulas to calcuate the revenue by product,
then created a formulas to rank by customer rankx
rankx(ALLSELECTED(Table[Customer column]),[Total Product X],,DESC,Dense)
then in coditional formating i based the conditional formatting on the ranking field
i tried to remove allselected and insert "all" only, but did not change.