Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @Anonymous can you please share sample dataset?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
54 | |
26 | |
23 | |
15 | |
9 |
User | Count |
---|---|
77 | |
61 | |
47 | |
17 | |
12 |