Filter logic which filters other filter dynamically

[Anonymous]

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 2nd row
if user selects biz_id=2 then team_id should filter 4 and show only last 2 rows.

logic should be somewhat similar to this

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

seq_id	biz_id	team_id	product
1	1	1	a1
2	1	2	a2
3	1	1	a2
4	2	1	a1
5	2	2	a2
6	2	3	a3
7	2	4	a1
8	2	4	a2

Thanks,

Raj

[V-lianl-msft]

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]

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 · Accepted solution]

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]

@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]

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