Forum Discussion
Dynamic Column based on aggregated measure
Hello all, I am trying to create a dynamic dimension based on a slicer, to do this I could use the switch function to populate a column based on a measurement such as max or min from a detached t...
HI Simon,
I have also tried this before but it won't work either. Remember I am trying to make a dynamic dimension which means I need a column to change value when a measurement does. If you input the calculate column value into a column it will alwyas read the max or min value of the total dataset, even if you filter or set any calculation filters.
What Power BI here really needs is a global variable that can be interchanged among tables and measurements.
