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.

Deku's avatar
Deku
Super User
1 year ago

Add a table visual with table 2 fields. Then add the following measure to the filter pane and filter not is blank.

 

var trip = SUMMARIZE( table2, table2[from], table2[to] )
var matchingFlight =
   CALCULATETABLE(
      table1,
      TREATAS( trip, table1[from], table2[to] )
   )
return
IF( NOT ISEMPTY( matchingFlight ), 1 )
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thank you but I didn't get it "Then add the following measure to the filter pane and filter not is blank." how to do this?