Forum Discussion

grggmrtn's avatar
grggmrtn
Post Patron
4 years ago
Solved

Need a [Measure] - Countrows by several categories, AND evaluating booleans

My data: PersonId ServiceName Year WeekNr Weekday Pause 1 Paper 2021 50 monday False 1 Paper 2021 50 tuesday False 1 Wood 2021 51 monday True 1 Wood 2021 51 tu...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    grggmrtn 

    Can you try this measure please:

    Billed = 
VAR __PAUSE = VALUES( Table2[Pause] ) 
RETURN
IF ( 
     COUNTROWS(Table2) = 2 && FALSE() IN __PAUSE , 
    1,
    0
)

     



Fowmy's avatar
Fowmy
Super User
4 years ago

grggmrtn 

Can you try this measure please:

Billed = 
VAR __PAUSE = VALUES( Table2[Pause] ) 
RETURN
IF ( 
     COUNTROWS(Table2) = 2 && FALSE() IN __PAUSE , 
    1,
    0
)