Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SELECTEDVALUE not Calculating

I'm having an issue with what should be a pretty simple calculation. I have a Calculated Column ( 0-$ ) that calculates a $ amount by way of looking at a related tables percentage. That is working fi...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Calculated columns do not refresh with slicer changes.  Are you referencing SELECTEDVALUE in a column expression?  If so, that won't work, but you can likely do your column calculation as a measure (if column not used as legend, axis, etc.).

    Regards,

    Pat

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Calculated columns do not refresh with slicer changes.  Are you referencing SELECTEDVALUE in a column expression?  If so, that won't work, but you can likely do your column calculation as a measure (if column not used as legend, axis, etc.).

Regards,

Pat

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Pat,

    That was it, thank you. I ended up with this expression and it worked. 

    0-$ (M) = (SUMX(Project,Project[LEFT TO SPEND])*SUMX(RELATEDTABLE(Profile),Profile[0]))*Variable[SelectedVariable]