- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @RajeshLM ,
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @RajeshLM ,
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)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @RajeshLM ,
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@RajeshLM , 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))
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
Online Event
Register Here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
07-28-2024 02:21 PM | |||
04-28-2024 10:39 PM | |||
08-16-2024 04:09 AM | |||
07-30-2024 09:57 PM | |||
Anonymous
| 10-31-2023 09:47 AM |
User | Count |
---|---|
126 | |
80 | |
59 | |
58 | |
44 |
User | Count |
---|---|
181 | |
121 | |
82 | |
70 | |
54 |