Forum Discussion
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, ...
Try
Num rows = COUNTROWS ( FILTER ( 'Table', 'Table'[Person Count] > 1 ) )
Thank you, that has worked it was so much simpler than i was expecting it to be.