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.