Forum Discussion
Adding a column messes up calculated measure
I have a pareto analysis set up with a table that contains all variables used for the analysis. When I want to add a new column that brings in more information, it seems to recalculate the rank measu...
Rank Equation
Rank =
if(HASONEVALUE('BOB_CL_Live - Name and Comm'[AccountName]),RANKX(ALLSELECTED('BOB_CL_Live - Name and Comm'[AccountName]),CALCULATE(SUM('BOB_CL_Live - Name and Comm'[Commission])),,DESC,Skip),"")