Manipulate Slicer Selection in a measure

[Gaurav_Lakhotia]

Hello members,

Need your help.

I have a Target & Year Slicer table. There are 3 columns Y1, Y2 & Y3 which are being used as slicers. There will be single select ON for the slicers.

I need help to write a measure which will calculate targets based on slicer selection. Means, when you select any year from slicer Y1, Y1 target measure needs to calculate according to it. Currently, it is not working.

Here is the file.

Thanks in advance.

@amitchandak 

[selimovd · Accepted solution]

Hey @Gaurav_Lakhotia ,

you are filtering the same table with the 3 slicers. In the background that ends up with an empty table because the filter combination doesn't exist. That's the reason you won't get the slicer-value from the table.

In order to work you have to split the 3 slicers to 3 different tables.

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

[Gaurav_Lakhotia]

Hi @selimovd , 

Thanks for the quick response. 

I got that the table is getting filtered. I'm looking for a solution to handle this using DAX.