Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter logic which filters other filter dynamically

Hi All, can you help in acheiving the below challenge which i am facing - below is the sample data what we have in our table. if user selects biz_id=1 then team_id should filter 2 and show only 2n...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    To be clear, measure can only be used as a visual level filter.

    Try create a calculated column.

    col = var max_team_id =  CALCULATE(MAX('Table'[team_id]),ALLEXCEPT('Table','Table'[biz_id]))
return IF('Table'[team_id]=max_team_id,1,0)

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Create a measure like this and apply it to visual level filter.

Measure = var max_team_id =  CALCULATE(MAX('Table'[team_id]),ALLEXCEPT('Table','Table'[biz_id]))
return IF(MAX('Table'[team_id])=max_team_id,1,0)

Sample .pbix

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks Liang.

     

    This 'Measure' working fine only for visual level filter pane. but we have muliple pages and multiple visuals in each page.

    when i try to add the 'Measure' in the page level filter pane, its not getting added.

     

    can you please help. how can i add this 'Measure' which should work across all pages.

     

    Thanks,

    Rajesh

     

    • V-lianl-msft's avatar
      V-lianl-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Anonymous ,

       

      To be clear, measure can only be used as a visual level filter.

      Try create a calculated column.

      col = var max_team_id =  CALCULATE(MAX('Table'[team_id]),ALLEXCEPT('Table','Table'[biz_id]))
return IF('Table'[team_id]=max_team_id,1,0)

       

      Best Regards,
      Liang
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.