Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
66 | |
49 |
User | Count |
---|---|
131 | |
110 | |
96 | |
70 | |
67 |