Forum Discussion

lazarus1907's avatar
lazarus1907
Icon for Helper I rankHelper I
5 years ago
Solved

Filter within filter?

Hi, I'm struggling to do this and I suspect the solution will involve nested filters, but I'm not getting any success so far.  Let me illustrate the problem with an example, because it's tricky to e...
DAX
Filters
  • lbendlin's avatar
    lbendlin
    5 years ago

    There are multiple ways to achieve this.

     

    In Power Query you can create reference queries and then group them as needed.

    In DAX you can create calculated columns that indicate inclusion/exclusion flags,  or you can create temporary tables, join them as needed ad then aggregate the results.

     

    Which approach do you prefer, Power Query or DAX?

     

    BTW, your first two sample outcomes for A and B are the other way round.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

There are multiple ways to achieve this.

 

In Power Query you can create reference queries and then group them as needed.

In DAX you can create calculated columns that indicate inclusion/exclusion flags,  or you can create temporary tables, join them as needed ad then aggregate the results.

 

Which approach do you prefer, Power Query or DAX?

 

BTW, your first two sample outcomes for A and B are the other way round.