Reply
Frequent Visitor
Posts: 3
Registered: ‎10-25-2018
Accepted Solution

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


Accepted Solutions
Highlighted
Super User
Posts: 2,139
Registered: ‎09-19-2016

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!




View solution in original post


All Replies
Highlighted
Super User
Posts: 2,139
Registered: ‎09-19-2016

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
Posts: 3
Registered: ‎10-25-2018

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

Thank you , that was it!