Forum Discussion
Create a measure from a variable table
Good afternoon, I am not able to complete one of my needed measures. My direct query table contains this structure: users steps 1 NEW 1 NEW 1 NEW 2 OLD 2 OLD 3 O...
Count the number of rows where "nº values" is three or greater.
COUNTROWS ( FILTER ( tabla, [nº values] >= 3 ) )
Count the number of rows where "nº values" is three or greater.
COUNTROWS ( FILTER ( tabla, [nº values] >= 3 ) )
🤣🤣🤣I just want to scream
I've been toying with several options, I didn't think about this possibility.
Thanks a lot.
There are plenty of other ways to do it too. E.g.
SUMX ( tabla, IF ( [nº values] >= 3, 1, 0 ) )