cancel
Showing results for
Did you mean:
Frequent Visitor

## SUM measur applying filter, but not for grand total

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User

## Re: SUM measur applying filter, but not for grand total

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

2 REPLIES 2
Highlighted
Super User

## Re: SUM measur applying filter, but not for grand total

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Frequent Visitor

## Re: SUM measur applying filter, but not for grand total

Thank you , that was it!