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.
I have two tables and oen is
and another is
I can select the distance using ZIP code and show the Zip Codes within the selected radious . My issues is I would like to see the data from second table based on Zip Code within that radius. The Second Table is using direct query and cannot use API function Is there a workaround for this using a DAX/PowerQuery
Solved! Go to Solution.
Hi @Tanyag ,
To better understand your scenario, I have some questions:
If there are no relationships between the two tables and the "Zip" slicer is based on 'Table1'[zip code], the "Maximum Distance (km)" is based on a What-if parameter, try to create a measure like below and set it as "is 1" when using it as a visual level filter.
Measure =
VAR SelectedZip =
SELECTEDVALUE ( 'Table1'[zip code] )
VAR SelectedRadious = [Maximum Distance (km)]
RETURN
IF (
MAX ( 'Table2'[zip] ) = SelectedZip
&& MAX ( 'Table2'[DistanceMI] ) <= SelectedRadious,
1
)
If this doesn't meet your requirements, please show me more details.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Tanyag ,
To better understand your scenario, I have some questions:
If there are no relationships between the two tables and the "Zip" slicer is based on 'Table1'[zip code], the "Maximum Distance (km)" is based on a What-if parameter, try to create a measure like below and set it as "is 1" when using it as a visual level filter.
Measure =
VAR SelectedZip =
SELECTEDVALUE ( 'Table1'[zip code] )
VAR SelectedRadious = [Maximum Distance (km)]
RETURN
IF (
MAX ( 'Table2'[zip] ) = SelectedZip
&& MAX ( 'Table2'[DistanceMI] ) <= SelectedRadious,
1
)
If this doesn't meet your requirements, please show me more details.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Icey
(sorry for delayed response I was on a walk)
As Far as relationship goes the common key field is ZIP code
The Zip I used is global city data (Open Source) It eventually is working
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 |