Forum Discussion
Anonymous
7 years agoNot applicable
Calculated Column/Table Change Dynamically According to Slicer Selection in the Report
According to this article, Calculated Column/Table Change Dynamically According to Slicer Selection in the Report, it is not possible to create a calculate column/table that can change dynamically wi...
- Anonymous7 years ago
Anonymous - Calculated Columns are created and stored in the table when the model is refreshed. The value stored in the row won't change according to the user selection.
What are you trying to accomplish?
Anonymous
7 years agoNot applicable
josephlim - You could have a binning measure, with a SWITCH statement, like:
binning measure = SWITCH( TRUE(), [value] <= 5, "0-5", [value] <=10, "6-10" "11+" )
I think for step 6, you could have a disconnected parameter table with a row for each rating. Then use that rating column in a new measure with a switch statement, like this:
rating measure =
SWITCH(
SELECTEDVALUE('Rating Table'[Rating],
1, <Calculate the 1 star>
2, <Calculate the 2 star>
3, <Calculate the 3 star>
4, <Calculate the 4 star>
<Calculate the 5 star>
)Then in the pie chart, you could add the rating column from the disconnected table, and the rating measure.
Hope this helps,
Nathan
josephlim
7 years agoFrequent Visitor
Anonymous
Works perfectly.
Thank you very much. Learnt something new today :)