Forum Discussion
Solved
Dynamic text
Hi all, I have a Running Total calculated column, where % of Total and Rank are also both calculated columns. Running Total =
CALCULATE (
SUM ('Table'[% of Total]),
FILTER (
...
Hello,
you can apply Text to measure, but you can't use them to group for Pivot.
Check_Value:=If([Running Total]>=0,8,'High','Low'). This should work.
This always checks your Running Total. If this value changes due to slicer it should update automatically.
Give it a try.
Hello,
you can apply Text to measure, but you can't use them to group for Pivot.
Check_Value:=If([Running Total]>=0,8,'High','Low'). This should work.
This always checks your Running Total. If this value changes due to slicer it should update automatically.
Give it a try.
