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 everyone!
I have 2 tables (AREAS and CALENDAR) and I want to join this tables with a condition:
Something like this:
So that when you filter for one year (for example 2017) you only show the values of that year (A1, A2 and A5) in another filter and when you filter for another year (for example 2018), your corresponding values (A1, A3, A4 and A5).
Is it possible create a measure for this situation? Is it possible filter a slicer with a condition for this case? Or may be I have to create a third table to link the others two?
Thank you for your help.
Solved! Go to Solution.
Hi @Raul
It is impossible to filter a slicer with a condition for this case. First way as you said, create a third table to link the others two. Second way, try to create a measure to get the table as requested. For example:
Measure = SWITCH ( SELECTEDVALUE ( 'Calendar'[year] ), 2017, IF ( MIN ( Area[Area] ) IN { "A1", "A2", "A5" }, 1 ), 2018, IF ( MIN ( Area[Area] ) IN { "A1", "A3", "A4", "A5" }, 1 ) )
Regards,
Cherie
Hi @Raul
It is impossible to filter a slicer with a condition for this case. First way as you said, create a third table to link the others two. Second way, try to create a measure to get the table as requested. For example:
Measure = SWITCH ( SELECTEDVALUE ( 'Calendar'[year] ), 2017, IF ( MIN ( Area[Area] ) IN { "A1", "A2", "A5" }, 1 ), 2018, IF ( MIN ( Area[Area] ) IN { "A1", "A3", "A4", "A5" }, 1 ) )
Regards,
Cherie
Thanks a lot @v-cherch-msft for your reply.
The second option, I think that can be works for me.
See you!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |