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

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