Issue with DAX filters over multiple tables

[Anonymous]

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.

[NidhiBhusari]

Hi @Anonymous can you please share sample dataset?