Forum Discussion
ChahindaAlyy
Microsoft Employee
Microsoft Employeecolor 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...
parry2k
Super User
Super UserChahindaAlyy 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.
ChahindaAlyyMicrosoft Employee
Microsoft EmployeeHi 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.