cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rmartin Frequent Visitor
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?

 

without filter_commented.png

 

 

with filter_commented.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
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
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!




rmartin Frequent Visitor
Frequent Visitor

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

Thank you , that was it!