Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Matrix group by code values and subtotal on those groups

Hello, Need a little assistance here and thanks in advance.   I have the following PBI report. And the main focus is program code, I need to group by program code and then subtotal by the program ...
Need Help
  • AilleryO's avatar
    AilleryO
    4 years ago

    Hi,

     

    You need to add an ALL or REMOVEFILTERS functions. They will help you to get rid of the filter "created" by your visual. Each line is a "filter" in your table.

    So to get the desied level of calculation, you need to remove those filters.

    If you add a CALCULATE (SUM(XXX), ALL(name of columns not to be considered as filters)

    or

    CALCULATE (SUM(XXX), REMOVEFILTERS(name of columns not to be considered as filters)

     

    Let us know

AilleryO's avatar
AilleryO
Memorable Member
4 years ago

Hi,

 

You need to add an ALL or REMOVEFILTERS functions. They will help you to get rid of the filter "created" by your visual. Each line is a "filter" in your table.

So to get the desied level of calculation, you need to remove those filters.

If you add a CALCULATE (SUM(XXX), ALL(name of columns not to be considered as filters)

or

CALCULATE (SUM(XXX), REMOVEFILTERS(name of columns not to be considered as filters)

 

Let us know