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!

    • 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.