Forum Discussion
omarevp
Helper II
Helper IIDistinctcount considering Average and some filters
Hi guys, I know this should be easy, but I need help. I have a list of professionals who have different number of works, every work has a "Score" depending on their performance; also, they ha...
Give this a shot
low score pros = CALCULATE ( COUNT ( 'public tuten_booking'[tuten_user_professional] ), 'public tuten_booking'[domain] <> "easy", 'public tuten_booking'[domain] <> "sodimac", FILTER ( ALLSELECTED ( 'public tuten_booking'[tuten_user_professional] ), [average] <= 3.8 ) )
v-jiascu-msft
Microsoft Employee
Microsoft Employee