Forum Discussion
DAX Filter
I am needing to apply the below filters to my entire PBI report and am having trouble with the the DAX filter. I am using three different columns in the same query.
Hi pschn1993 ,
Based on your description, you see that you can try to use the alexpected function in the formula to keep the results of the external filtering context for the check weigher, date, and check weigher zone fields.
At this point, the only external filtering context is the color:
When I add more filters, I can keep the results of the filters on the corresponding columns with the allexpected function.
amount = CALCULATE ( SUM ( FactInternetSales[SalesAmount] ), ALLEXCEPT ( DimProduct, DimProduct[Color], DimProduct[Class] ), ALLEXCEPT ( DimDate, DimDate[FiscalYear] ) )If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi pschn1993 ,
Based on your description, you see that you can try to use the alexpected function in the formula to keep the results of the external filtering context for the check weigher, date, and check weigher zone fields.
At this point, the only external filtering context is the color:
When I add more filters, I can keep the results of the filters on the corresponding columns with the allexpected function.
amount = CALCULATE ( SUM ( FactInternetSales[SalesAmount] ), ALLEXCEPT ( DimProduct, DimProduct[Color], DimProduct[Class] ), ALLEXCEPT ( DimDate, DimDate[FiscalYear] ) )If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
