using filters without adding new rows

[zoubeyrB]

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]))

Is there a way to solve this issue just by modifying the measure (without adding new columns) ?

Thanks in advance,

[Anonymous]

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

[zoubeyrB · Accepted solution]

Hello,

Using a star schema did solve the issue, thanks.

Best regards,