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!

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

JFGrenier Just change the data model a little bit and the DAX that you have to write will be short and simple, working PBI file is attached below my signature: