conditionaly formating with second value

[patrick1192]

Hi all,

I'm currently having problems implementing a use case.
I want to perform conditionally formatting on a table.

If the "failed" value for a main element is "1",

all subelements with the same PhysicalID should be conditionally formatted green (regardless of the "failed" entry of the subelements)

In the example,  the following lines should be (green) formatted:

In the productive case, several main elements can have the "failed" value 1.
Furthermore, the data is in the productive PBI via DirectQuery from Kusto.

I have tried a few things with measures, but unfortunaly i don´t get a solution so far.

Hopefully i have made myself clear, so that you can understand what my problem is.

Thanks for your help!

[danextian · Accepted solution]

Hi @patrick1192 

I'm not sure if this will work in direct query but try:

IF (
    CALCULATE (
        MIN ( data[failed] ),
        FILTER ( ALLEXCEPT ( data, data[physicalid] ), data[model] = "main-element" )
    ) = 1,
    "color"
)

[patrick1192]

Hi @danextian ,

your code is working with a table visual (even with directquery!) Perfect!

When i use a matrix visual, the code is only working when i take the phsyicalID in a column.

Is there any chance to get this code working in a matrix when the physicalID is also a value ?

Thanks for your Help!

[danextian]

The measure is evaluated for each cell in the matrix, depending on the row and column headers. Not using the physicaID as a row or column dimension will return an unexpected result. Try using that formul as a calculated column instead. If it is not supported in DQ, your other option is to create such in column in the source itself.