Forum Discussion

patrick1192's avatar
patrick1192
Frequent Visitor
2 years ago
Solved

conditionaly formating with second value

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 t...
Need Help
Tips and Tricks
  • danextian's avatar
    danextian
    2 years ago

    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's avatar
patrick1192
Frequent Visitor
2 years ago

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's avatar
danextian
Super User
2 years ago

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.