Forum Discussion

zoubeyrB's avatar
zoubeyrB
Frequent Visitor
5 years ago
Solved

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]))
Is there a way to solve this issue just by modifying the measure (without adding new columns) ?
 
Thanks in advance,
  • zoubeyrB's avatar
    zoubeyrB
    5 years ago

    Hello,

    Using a star schema did solve the issue, thanks.

    Best regards,

2 Replies