Forum Discussion

jman738's avatar
jman738
New Member
3 years ago

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 measure and messes the table up. It assigns a rank of 1 to about 10 accounts and a rank of 2 to about 10 accounts and so on. .

 

Why would bringing in another column recalculate my rank column?

 

 

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    3 years ago

    jman738 you need to provide how you are calculating rank to better understand the issue.

  • jman738's avatar
    jman738
    New Member
    3 years ago

    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),"")