Smart Slicers for duplicates detecting

[Anonymous]

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

[v-yuta-msft]

@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.