Forum Discussion

Susan513's avatar
Susan513
Helper II
2 years ago
Solved

Return value if all rows in multiple categories match

Looking for solution to evaluate multiple rows based on multiple categories. In my example, I want to know per site, per category - if all the documents in the sites' category are resolved for the si...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

    RESULT = 
VAR _t1 = CALCULATE(COUNTROWS(),ALLEXCEPT('Table','Table'[Site],'Table'[Category]))
VAR _t2 =  CALCULATE(COUNTROWS(),ALLEXCEPT('Table','Table'[Site],'Table'[Category]),'Table'[Status]="Resolved" )
RETURN
if (_t1 = _t2 ,"Complete", "Incomplete" )
Ahmedx's avatar
Ahmedx
Super User
2 years ago

pls try this

RESULT = 
VAR _t1 = CALCULATE(COUNTROWS(),ALLEXCEPT('Table','Table'[Site],'Table'[Category]))
VAR _t2 =  CALCULATE(COUNTROWS(),ALLEXCEPT('Table','Table'[Site],'Table'[Category]),'Table'[Status]="Resolved" )
RETURN
if (_t1 = _t2 ,"Complete", "Incomplete" )
Susan513's avatar
Susan513
Helper II
2 years ago

Thank you - this is working, I appreciate you!