Using the Min Number to do conditional formatting

Anonymous — Sat, 11 May 2024 03:33:15 GMT

Hello,

I have a table where I'm trying to perform conditional formatting. I have a measure where I'm calculating the MIN of the Reprint Rate Column. However, there's something funky going on where there's no relationship to the row and so I can't compare the reprint rate to the Best in Network measure.
Ultimately, I'd like to compare the Reprint Rate against the Best in Network and if its the value then it should be green otherwise red.

Here are the measures:

Best in Network = MINX({[SC01_%], [SC02_%], [SC03_%], [SC04_%], [SC05_%]}, [Value])

Reprint Rate = IFERROR([Reprints]/[__Printed],0)

Reprint Color = IF('Reprints and Printed'[Reprint %] = [Best in Network], 1, 0)

Does anyone have any recommendations? THANK YOU IN ADVANCE!

Re: Using the Min Number to do conditional formatting

DataNinja777 — Sat, 11 May 2024 05:24:21 GMT

Hi Anonymous

You can produce your required output by wrapping the table with 'all' to ignore row filter context in Minx function.

Minx = minx(all('Table'),'Table'[Reprint Rate])

Then you can use the conditional formatting on the measure to specify the color as you require.

I attach an example pbix file.

topic Re: Using the Min Number to do conditional formatting in DAX Commands and Tips

Using the Min Number to do conditional formatting

Re: Using the Min Number to do conditional formatting