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.

v-ssriganesh's avatar
v-ssriganesh
Community Support
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.

  • v-ssriganesh's avatar
    v-ssriganesh
    Community Support
    1 year ago

    Hi Anonymous,
    I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
    Thank you.