SUM measur applying filter, but not for grand total

[rmartin]

Hi,

I have a grid displaying total of hours for each categories and a total in the bottom. I want to be able to filter categories so it displays only the ones I chose, but the total of hours in the bottom must be for all categories, even if they are not displayed.

Is it feasable? How can I create that measure?

[MFelix · Accepted solution]

Hi @rmartin,

I'm assuming that the column you have on your table is a measure so you need to apply something like this:

NB =
IF (
    HASONEFILTER ( Table[Categorie] );
    [Measure];
    CALCULATE ( [MEASURE]; ALL ( Table[CATEGORIE] ) )
)

Regards,

MFelix

[rmartin]

Thank you MFelix, that was it!