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.
Hi,
I have a slicer that filters on the field 'StatusReason' (Active vs Inactive)
This is how the list looks when both fields are selected
The rows with arrows are duplicate entries with the different values of 'Status Reason'.
If I use the 'Inactive' selection, the duplicate entry obviulsy get displayed based on the status reason.
So the question is how would I be able to check if the course particpant exists with an active status an not show on the inactive list.
One solution would be to just detect duplicates and remove the inactives in PQ, but I need the inactive entries for other calculations.
I think I need to write a separate DAX columns for both active and inactive(that are not active) which could detect duplicates, and then use a slicer....however other suggestions are also welcome
Thanks,
Fowaz
@Anonymous ,
@Anonymous wrote:
Hi,
I have a slicer that filters on the field 'StatusReason' (Active vs Inactive)
This is how the list looks when both fields are selected
The rows with arrows are duplicate entries with the different values of 'Status Reason'.
If I use the 'Inactive' selection, the duplicate entry obviulsy get displayed based on the status reason.
So the question is how would I be able to check if the course particpant exists with an active status an not show on the inactive list.
One solution would be to just detect duplicates and remove the inactives in PQ, but I need the inactive entries for other calculations.
I think I need to write a separate DAX columns for both active and inactive(that are not active) which could detect duplicates, and then use a slicer....however other suggestions are also welcome
Thanks,
Fowaz
Could you clarify more details about the expected result?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |