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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello, I was able to use the dax and create the measure column. So thank you.

See image. It does end up having a column (Prog Total) with that data valuesTesting repeating.

 

I really want the format to be the same as the excel example, is this feasible do you know of a way to make the matrix look like the spreadsheet example? Or should I create another post for the format of the matrix? I have been toying around with it and just cannot have it appear the way ths spreadsheet does. Thanks again.

  • AilleryO's avatar
    AilleryO
    Memorable Member
    4 years ago

    Hi,

     

    You'll not get something exactly as it is in Excel, but if you use the visual called Matrix (not Table), you should be able to get something quite close 😉

    same, same but different 😉

    The idea of a new topic concerning only the display/formatting, sounds good to me as well.

    Have a nice day,