Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 fine. I'd like to have that calculation be multiplied by a SELECTEDVALUE Measure that is looking at a seperate slicer table and is selected by a slicer. I cannot get that aspect to work as it yeilds blanks in the column that was previously working.
I've tried changing formats, adding VALUES, putting the calculation in a Variable... to no avail.
Here's a capture of the calculation working prior to introducing the SELECTEDVLAUE into it:
Here's a capture after I add in my SELECTEDVALUE Measure:
Thoughts and feedback appreciated.
Thank you,
-Nate
Solved! Go to Solution.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |