Turning a measure into a column that updates dynamically

[Anonymous]

 Hi,  Newish to BI so help would be much appreciated 🙂

I have a calculated measure in a table in PowerBi desktop report, to create some customer brackets based on Cash flow over past 30 days.
This measure is generated with inputs that can be adjusted via sliders to indicate & increases, which impact on the adjusted cash bracket

However I need to turn use this measure data in a matrix/chart and I cannot use the measure on the legend or axis on chart.

Here is what the table looks like at a customer level.

The last column is the measure I have created, based on the following DAX

CashBracket Adjusted = IF(CustomerProfile[Cash Last 30 Adjusted] <=0, "5.Distressed",

IF(CustomerProfile[Cash Last 30 Adjusted] <= 200, "4.Stretched", IF(CustomerProfile[Cash Last 30 Adjusted] <= 400,

"3.Ticking Over", IF(CustomerProfile[Cash Last 30 Adjusted] <= 1000, "2.Comfortable", "1.Secure")))

I have tried to create a column that references the measure outputs, but it appears that this column doesnt update when I adjust the filters/sliders.

Where I would expect to see a new result( cash bracket) on a row, it appears as it is just showing the original Cash Bracket value, and not the new one.

Look forward to any ideas

Cheers

[dax]

Hi Matt_Mcmillin, 

You should know calculated column is different from measure, they refer to different context. And calculated Column  can't based on  slicer context. You need to use measure to achieve this goal. You  could inform me more detailed information (such  as your sample and  your expecting output).

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, 
I have looked at this again and have tried to create a column that references the Measure( "Cash Bracket Adjusted") and uses Variables as per the DAX below

CashBracket Adjusted1 =

VAR CASHADJUSTED = CustomerProfile[CashBracket Adjusted]

VAR BRACKET = IF(CASHADJUSTED = "5.Distressed", "5.Distressed", IF(CASHADJUSTED = "4.Stretched", "4.Stretched", IF(CASHADJUSTED= "3.Ticking Over", "3.Ticking Over", IF(CASHADJUSTED = "2.Comfortable", "2.Comfortable", IF(CASHADJUSTED = "1.Secure", "1.Secure", "No")))))

RETURN BRACKET