Measure will not filter

[Anonymous]

Guys, do you know what could be an issue with this measure ? I want to use it in couple of visuals with different date filters and now it will not take those visual level filters. My calendar table is filtering 'Teams statistics' 1 to many.

YES count =

VAR min_level =

MIN ( 'user AD'[User Org Level] )

return

CALCULATE (

DISTINCTCOUNT ( 'Teams statistics'[User Principal Name] ),

'Teams statistics'[Teams Channels] = "Yes",

'user AD', 'user AD'[User Org Level] <> min_level)

[Anonymous]

@Anonymous  Hey Mate ,
Can you try this Measure.

Yes count=
CALCULATE (
DISTINCTCOUNT ( 'Teams statistics'[User Principal Name] ),
FILTER(Teams statistics'[Teams Channels] = "Yes"
))

[amitchandak]

@Anonymous , Try like

YES count =
VAR min_level = MINX ('user AD', 'user AD'[User Org Level] )
return
CALCULATE (
DISTINCTCOUNT ( 'Teams statistics'[User Principal Name] ),
'Teams statistics'[Teams Channels] = "Yes",
filter('user AD', 'user AD'[User Org Level] <> min_level))

Appreciate your Kudos!!

[Anonymous]

Thanks, @amitchandak , that did not work. I think the issue lies in 'Teams statistics'[Teams Channels]  and it is calculated column for YES count per user:

Teams Channels =

VAR current_user = 'Teams statistics'[User Principal Name]

VAR amount_per_user =

CALCULATE(SUM('Teams statistics'[Team Chat Message Count]), FILTER('Teams statistics','Teams statistics'[User Principal Name]=current_user))

return

IF(amount_per_user>=2, "Yes", "No")

[wdx223_Daniel]

@Anonymous if calculate column is right in its table, then Measures calculation in visual will not affect the calculated column's result.

better show your sample data and expected result