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 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
Solved! Go to 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
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
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.
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 |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |