Forum Discussion

jmarcrum's avatar
jmarcrum
Helper II
6 years ago
Solved

MAX LOD Expression

Hi everyone -

 

I have a table viz that shows CR#'s and their Related Records.  Each CR# can have multiple Related Records (as shown in the screenshot below).  I'm trying to determine (by the WORK_DONE column) if ALL of the work has been done on the CR#. 

 

I'd like a column that says "All work done" if all related records have a 1 in the WORK_DONE column or "Still work to do" if there is a 0 on any of the related records in the WORK_DONE column.  Can this be done?

 

Thanks in advance for the help!

 

 

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    jmarcrum you can add a column using the following expression.

     

    Work Done Status = 
VAR  __count = 
COUNTROWS( 
    CALCULATETABLE( 
        VALUES ( Table[Work_Done] ), 
        ALLEXCEPT ( Table, Table[CR #] ), 
        Table[Work_Done] = 0
    ) 
)
RETURN IF ( __count > 0, "Not", "All Work Done" )

     

    Would appreciate Kudos 🙂 if my solution helped.

     

    Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    jmarcrum you can add a column using the following expression.

     

    Work Done Status = 
VAR  __count = 
COUNTROWS( 
    CALCULATETABLE( 
        VALUES ( Table[Work_Done] ), 
        ALLEXCEPT ( Table, Table[CR #] ), 
        Table[Work_Done] = 0
    ) 
)
RETURN IF ( __count > 0, "Not", "All Work Done" )

     

    Would appreciate Kudos 🙂 if my solution helped.

     

    Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com