Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Data Match and Selection

Thank you upfront. I have 2 tables already imported into PBI as below, wonder how to create a view to filter out records from Table 2 based on Table 1 that only with Direct Flight Avaliable? As a re...
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    Hi Anonymous,
    Thank you for reaching out to the Microsoft Fabric Forum Community and thank you, kushanNa for sharing your valuable insights.

    I have reproduced your scenario using the DAX code provided by kushanNa. For your reference, I have attached the .pbix file.

    If this helps, then please “Accept it as a solution” and dropping a "Kudos" so other members can find it more easily.
    Hope this works for you!
    Thanks.

kushanNa's avatar
kushanNa
Icon for Super User rankSuper User
1 year ago

Hi Anonymous 

 

If you want to do this from Dax side please follow the following steps 

 

click on modeling new table 

 

 

copy and past the following code to create a Dax calculated table

 

FilteredTrips = 
FILTER(
    'Planned Trip List',
    LOOKUPVALUE(
        'Direct Flight List'[To], 
        'Direct Flight List'[From], 'Planned Trip List'[From], 
        'Direct Flight List'[To], 'Planned Trip List'[To]
    ) <> BLANK()
)

 

you can see the table on the Table view