Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter context

Hi all. I can not seem to figure out the filter context and calculated column will not give me the expected results. The measure is the following: Teams Channels = VAR current_user = 'Teams stati...
Need Help
AntrikshSharma's avatar
AntrikshSharma
Community Champion
5 years ago

Anonymous  Is 'Teams statistics'[User Principal Name] a measure or a refrence to a column or you didn't wrap inside SELECTEDVALUE?

Try this:

 

Teams Channels =
VAR current_user = 'Teams statistics'[User Principal Name]
VAR amount_per_user =
    CALCULATE (
        SUM ( 'Teams statistics'[Team Chat Message Count] ),
        'Teams statistics'[User Principal Name] = current_user,
        REMOVEFILTERS ( 'Teams statistics' )
    )
RETURN
    IF ( amount_per_user >= 2, "Yes", "No" )

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

AntrikshSharma 

Thank you and apologies, this is not the measure but calculated column I am trying to get as eventually I will have to count "Yes'es" and not sure if masure will serve this purpose...?

 'Teams statistics'[User Principal Name]  is a column, and I di not wrap it in VALUES. 

I am afraid your suggestion still gives me same result 😞