Forum Discussion
Solved
Count If measure
Hello I am trying to create a measure that returns the percentage of customers with 3 or more logins. My dataset is a list of CustomerIDs and timestamps (logins) where one row equals one login. I...
Measure =
VAR __Table =
FILTER(
SUMMARIZE(
'Table',
[KundeID],
"__Count", COUNTROWS('Table')
),
[__Count] > 3
)
RETURN
COUNTROWS(__Table)
Measure =
VAR __Table =
FILTER(
SUMMARIZE(
'Table',
[KundeID],
"__Count", COUNTROWS('Table')
),
[__Count] > 3
)
RETURN
COUNTROWS(__Table)
Hi Greg
This is friggin amazing. Thank you very much!
- Cool, glad it worked for you! 🙂
