Calculated column and measure different values?

[Kassii]

Hi guys

Wondering if someone could help me out please.

Currently I have a bunch of measures which are calculating values and they're are working as expected. Because (From what I have seen) power bi doesn't allow measures to have conditional formating, I need to place these values into columns, However placing them on a calc column will obviously give sum of that calculation on every row there is.

Is it possible to just put that exact value from the measure into the column, even it gets placed on every line and I can just used the Min or Max (it would be the same value anyways)

Thanks

[v-chuncz-msft]

@Kassii,

Check if you could use SUMMARIZE Function to add a calculated table.

[parry2k]

@Kassiishare sample data and expected result. Condiional formatting works with measures with number value

[Kassii]

How do I assign the conditional formating? I have tried right clicking the field -> Conditional Formating -> background colour scales and that doesn appear to want to work?

The issue is however that the formula being used on the measure, when applied to the column, calculates it for every row. Expected result in the image above and the result I am getting

[parry2k]

Could you share what is your measure like? What you are trying to do and what are the expected result? Sample data will be helpful.