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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Issue with DAX filters over multiple tables

Issue with DAX filters over multiple tables

We have been trying hard to find a fix for the complex Power BI Report builder reports filters in DAX. Basically the reports which use multiple AND/OR conditions or nested filters conditions.

'Dim Buyer Detail'[BuyerDetailStatus]= "Active" but our requirement is to filter the data using DAX query for multiple tables / conditions using AND/OR conditions.


For example we are looking for something like

FILTER('Dim Buyer Detail','Dim Buyer Detail'[BuyerDetailStatus]= "Active",'Dim Employee'[Employee Name]='XYZ','Dim Customer'[Customer Name]='ABC')

We have tried many ways, but unfortunately, we are unable to find a usable solution for complex reports filters in DAX. We tried to put dataset filters for OR/AND conditions, but that slows down the performance very much so it is not a very practical solution.

 

1 REPLY 1
NidhiBhusari
Helper IV
Helper IV

Hi @Anonymous can you please share sample dataset?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.