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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Assuming biz_id Id will filter because of slicer value

 

measure =
var _team = if(selectedValue([biz_id]) =1 ,2 ,4)

return
calculate(Countrows(Table), filter(Table,Table[team_id] =_team))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    yes biz_id can be a filter but i am not able to get the desired output with this solution. can you pls share the pbix file.

    output should should be the table based on below condition.

    if ( biz_id=1 and team_id=2) or ( biz_id=2 and team_id=4) then show the respective rows