Forum Discussion
using filters without adding new rows
Greetings,
I'm having an issue with the way DAX handles relationships, so here's an example I'm currently working on :
First case : all filters are from the same table :
In this case it works just fine, when I add the following measure no inexistant combinations are added:
2.removeLabel = CALCULATE(SUM(test[sales]), REMOVEFILTERS(test[product_label]))Second case : filters are from different tables :
In this case using the exact same expression leads to the apparition of new inexisting combination of values for the different filters
1.removeLabel = CALCULATE(SUM(sales[quantity]), REMOVEFILTERS(labels[Label]))Hello,
Using a star schema did solve the issue, thanks.
Best regards,
2 Replies
- AnonymousNot applicable
Hi zoubeyrB
Please remove the cross-filters from the model... and best just create a simple decent model and get rid of the one above (which is, to simply put it, incorrect). You'll have a much better (quality of) life in no time 🙂
Here's something to get you started on the right foot:
Understand star schema and the importance for Power BI - Power BI | Microsoft Docs
- zoubeyrBFrequent Visitor
Hello,
Using a star schema did solve the issue, thanks.
Best regards,