topic Measure connected with table cell in DAX Commands and Tips

Measure connected with table cell

ManishML — Tue, 23 Aug 2022 11:40:24 GMT

I want to make something like : a table is connected with a measure, If the measure value is 5 and in a table if some of the cell having a value greater or equal then that, it simply diffrenciate that cell by a color or anything which could highlight.

I tired this, but its not working.

Test2 =
VAR Value = ('Name'[Values])
RETURN
IF (
Value < ('Name'[Valuesss]), "#0E8155"

Re: Measure connected with table cell

Syk — Tue, 23 Aug 2022 13:22:08 GMT

Check out the conditional formatting for the table visual, you can set background color and lots of other settings!

Apply conditional table formatting in Power BI - Power BI | Microsoft Docs

Re: Measure connected with table cell

v-yadongf-msft — Wed, 07 Sep 2022 06:18:07 GMT

Hi ManishML

The measure I created:

Valueness = MAX('Name'[Values])/2 formatting = IF('Name'[Valueness] >= 5,"red")

Click “Values” field, check “Conditional formatting”-“Font color”.

Then check “Field value”-“formatting”.

Finally, you can simply differentiate that cell by a color like below:

If I misunderstand your demands, please provide some data screenshots (remember to hide sensitive information) to help us better solve your problem.

Best regards,

Yadong Fang

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