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.
