Need help to Create Virtual Table

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.?

Need Help

Ahmedx
2 years ago
if you follow my logic calculation I think you will go do it

Forum Discussion

Need help to Create Virtual Table

3 Replies

Related content

Fabric virtual table

Dax Logic Issue virtual Table

Create new table

Create Measure From Virtual Table

Lakehouse Table Generate Create Table