Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I am making a report looking at attended events.
However I am trying to Filter on a specific event, and then show who attened that event, and which other events they have attened.
The issue is that because im filtering from the same collum as the results i am trying to show, when i filter on Event 1, it shows me who attened, but not the other events they attened.
Any help is appreciated!
thanks
Solved! Go to Solution.
Hi @Anonymous
You could build a Slicer table by event column and build a measure and use filter field to achieve your goal.
My Sample Table:
Slicer Table:
Table 2 = VALUES('Table'[Event])
Measure:
Measure =
Var _Sel = SELECTEDVALUE ( 'Table 2'[Event] )
RETURN
CALCULATE (
MAX ( 'Table'[User] ),
FILTER (
ALLSELECTED ( 'Table'[Event] ),
'Table'[Event] = _Sel
)
)
Drag measure into Filter Field and show items when the value is not blank.
When we select Event1 it will show A,C,D and all events they have.
You can download the pbix file from this link: Help with Filtering
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
See if my solution here helps - Filter a column of a Pivot Table on a certain condition but also show other items from that column.
Hi @Anonymous
You could build a Slicer table by event column and build a measure and use filter field to achieve your goal.
My Sample Table:
Slicer Table:
Table 2 = VALUES('Table'[Event])
Measure:
Measure =
Var _Sel = SELECTEDVALUE ( 'Table 2'[Event] )
RETURN
CALCULATE (
MAX ( 'Table'[User] ),
FILTER (
ALLSELECTED ( 'Table'[Event] ),
'Table'[Event] = _Sel
)
)
Drag measure into Filter Field and show items when the value is not blank.
When we select Event1 it will show A,C,D and all events they have.
You can download the pbix file from this link: Help with Filtering
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Try a measure like
measure =
var _tab = summarize(filter(allselected(Table), table[user]))
return
calculate([measure], filter(all(Table), Table[user] in _tab))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |