Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Shri_mukherjee
Frequent Visitor

Disconnected table and slicer selection

I am making a report where I have airline information like as shown. The original data contains the airport codes in 3 splitted columns. I performed Look Up on each of the rows in each column to get the Country name. I inserted calculated column names Route 1- Route 2, Route 2- Route 3. NOw the problem I am facing are (1) since this lookup and concatenation is performed in the modelling tab, I am not able to perform unpivot to bring all the Routes in the same column. Is there a way to unpivot outside Power Query? (2) To workaround, I prepared a look up table named Route and wrote a DAX code to calculate the count of routes distributed in two columns. However the values are not varying with the slicer selection since the Look up table and the master table are disconnected. What DAX will make the values vary with the change of airline name? Please helpScreenshot (167).pngScreenshot (168).pngScreenshot (169).png

1 REPLY 1
Anonymous
Not applicable

Why can't you use Power Query?

Best
D

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.