Forum Discussion
Dynamic value in calculated column
Hi Oded-Dror
Calculated columns and tables are calculated on refresh and after that they are static.So a slicers will impact which rows of a table are used but not the content itself. A measure could create this result, but you cannot use measure results in a slicer.
So sorry I do not think this is possible.
Best regards,
Jeroen Dekker
Hi Oded-Dror ,
According to your description, you want the calculated column slicer changed according to the country slicer, it cannot be achieved, as tables and calculated columns are established prior to the query and don't change - only get filtered. So the calculated column can be calculated the right value in the data view, then it will be filtered by the country slicer.
In your snapshot, the sub category value depends on the measure revenue, I guess the measure has a SUM function, so the value will always be the sum value. You can modify your measure, or post the formula of the measure if needed, as your sample link cannot be connected.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you
