Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Showing group status

Hi, 

 

I have some data that has a group name column, an individual name column and a status column (1 for active, 2 for inactive).

 

Is there a way to show the entire group as inactive if atleast one item is inactive? 

 

Any help would be greatly appreciated.

Need Help
  • PattemManohar's avatar
    PattemManohar
    6 years ago

    Anonymous Please try adding a NewStatus field as below

     

    NewStatus = 
VAR _Status = MAXX(FILTER(Test09,Test09[Group]=EARLIER(Test09[Group])),Test09[Status])
RETURN _Status

1 Reply

  • PattemManohar's avatar
    PattemManohar
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous Please try adding a NewStatus field as below

     

    NewStatus = 
VAR _Status = MAXX(FILTER(Test09,Test09[Group]=EARLIER(Test09[Group])),Test09[Status])
RETURN _Status