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"
)

     

danextian's avatar
danextian
Super User
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!