Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
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.
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.
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
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.
@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))
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
136 | |
111 | |
98 | |
97 | |
92 |