Im trying to make a custom filter slicer but i don't seem to be able to make it work

[Yordi_Soto]

I have a table with column "Tipo de curso" with 5 types of values "Inducción" "Liderazgo" "Profundización" "Curso SD" and "Refuerzo/Simulación".

And id like to add a slicer with three options.

1.- "Nueva unidad" (Don't filter out anything)

2.-"Con expediente" (Filter out "Refuerzo/Simulación")

3.-"Sin expediente" (Filter out "Refuerzo/Simulación" AND "Curso SD")

I tried using a calculated table and tried linking it up with a measure but it doesn't seem to work.

And this is the measure but it doesn't seem to recognize it

[selimovd]

Hey @Yordi_Soto ,

if you create a relationship to the column "Tipo de curso", you can use the column as a filter.

But in general you cannot do a relationship to a measure.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic