Dynamic text

[RMDNA]

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 (
        ALL ('Table'),
		'Table'[Rank] <= EARLIER ('Table'[Rank])
    ))

What I'm looking to do is to check that value, and if it's beyond a certain threshold (say, 80%), assign it a text value ("High", for example). However, it also needs to be dynamic - if a set of filters would drop that number below 80%, it would get renamed to "low."

Assigning a text value is usually for columns, dynamic things are for slicers. Is there any way to get the result I need?

[Floriankx · Accepted solution]

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.

[RMDNA]

@Floriankx,

This worked great, thanks! I need to take things one step further, but I'll break that into another post.