Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Counting Total excluding Missing Values

Good Afternoon   I need some help with a measure please.   In my data i have the below:   EventCode,  Month,  Person Count 1,                    1 ,           1,                    2,        ...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    Try

    Num rows =
COUNTROWS ( FILTER ( 'Table', 'Table'[Person Count] > 1 ) )
johnt75's avatar
johnt75
Super User
3 years ago

Try

Num rows =
COUNTROWS ( FILTER ( 'Table', 'Table'[Person Count] > 1 ) )