Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Measure will not filter

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)
Nee dhelp

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        wdx223_Daniel
        Community Champion
        5 years ago

        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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous  Hey Mate ,
    Can you try this Measure.

     

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