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.
Hi All,
I need a help to create Virtual Table -
I have a dropdown slicer. Based on the Dropdown slicer selection i need to caluculate the distance from the selected location to existing table locations. I am using measure for caluculation part. I am able to get all the location distance from the selected location.
It is working fine for single selection as Expected (Example below)
Single Selection | |||
Selected Value in the Slicer Dropdown | ABC | ||
Table | |||
Name | Location | Amount | Distance(Using Measure) |
ABC | Location1 | 1000 | 123 |
BCD | Location2 | 1001 | 234 |
CDF | Location3 | 1002 | 345 |
DEF | Location4 | 1003 | 567 |
EFG | Location5 | 1004 | 123 |
FGH | Location6 | 1005 | 278 |
If i select multiple locations in the dropdown, Power BI is confused to caluculate the distance. I need a way to caluculate multiple selections. (i think it can be possible using Virtual table as below.)
Multiple Selection | ||
Selected Value in the Slicer Dropdown | ABC, BDC |
Table | |||||
Name | Location | Amount | Distance(Using Measure) | Selected Value | |
ABC | Location1 | 1000 | 123 | ABC | |
BCD | Location2 | 1001 | 234 | ABC | |
CDF | Location3 | 1002 | 345 | ABC | |
DEF | Location4 | 1003 | 567 | ABC | |
EFG | Location5 | 1004 | 123 | ABC | |
FGH | Location6 | 1005 | 278 | ABC | |
ABC | Location1 | 1000 | 123 | BDC | |
BCD | Location2 | 1001 | 234 | BDC | |
CDF | Location3 | 1002 | 345 | BDC | |
DEF | Location4 | 1003 | 567 | BDC | |
EFG | Location5 | 1004 | 123 | BDC | |
FGH | Location6 | 1005 | 278 | BDC |
Can anyone guide me on this approach.?
Solved! Go to Solution.
if you follow my logic calculation I think you will go do it
Hi @Ahmedx ,
Thanks for your Quick help. I can use this. In my case the @slicer value we are getting from other table. As we are having 2.5L records in the Other table. Can we caluculate the Virtual table only the values after slicer select?
if you follow my logic calculation I think you will go do it
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 |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |