Forum Discussion

JFGrenier's avatar
JFGrenier
Frequent Visitor
6 years ago
Solved

Excel DAX query with bridge table using CROSSFILTER

Hi, this is my second take on a problem I have using the correct syntax on an Excel DAX query:     I did a working measure in powerpivot using a pivot table with filters: CountryGr...
  • AntrikshSharma's avatar
    AntrikshSharma
    6 years ago

    JFGrenier  Sure, that's the best decision, you may write a complex DAX that might break tomorrow if not written considering every possible detail, but a data model that's perfect would always give you the required soution with minimal DAX!

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
6 years ago

Weird that my previous reply disappeared without any trace ...🤔

JFGrenier IMHO, in order to propagate filter from multiple(*) side to one(1) side of a relationship, expanded table would be a preferable choice.

As to your issue, filters on CountryGroup(*) can take effect to Country(1) this way,

 

CALCULATETABLE ( VALUES ( Country[IdCountry] ), CountryGroup )

 

then such a filtering propagates naturally from Country(1) to DataTable(*) subsequently.

Pls try measure

 

Total Values :=
CALCULATE (
    SUM ( DataTable[Value] ),
    CALCULATETABLE ( VALUES ( Country[IdCountry] ), CountryGroup )
)