Ignore specific filters applied in table total values

[Anonymous]

Team, I have a table with 6 categories as below

Category	OrderMonth	Price	MRP
A	Jan	879	1,029
B	Jan	5,645	5,795
C	Jan	564	714
D	Jan	8,975	9,125
E	Jan	5,643	5,793
F	Jan	321	471
A	Feb	213	363
B	Feb	5,464	5,614
C	Feb	654	804
D	Feb	854	1,004
E	Feb	63	213
F	Feb	564	714
Total		29,839	31,639

In the Filters pane, I have applied OrderMonth = Jan and Category <> F. But, in my output table I need the Total should Ignore the Category Filter which I had applied as Category <> F and should SUM the Price, MRP for all categories in Jan (including category F). But, category F should not be seen in the output table as mentioned below.

Note: Price, MRP are measures.

Category	OrderMonth	Price	MRP
A	Jan	879	1,029
B	Jan	5,645	5,795
C	Jan	564	714
D	Jan	8,975	9,125
E	Jan	5,643	5,793
Total		22,027	22,927

Any help is much appreciated.

Thanks,

[Anonymous]

HI @Anonymous,

I'd like to suggest you add if statement to your measure formula to check the row content level. If current is 'total' level, you can write a formula to add filter records calculation result with enabled filter effect.

Clever Hierarchy Handling in DAX 

Regards,

Xiaoxin Sheng

[Mariusz · Accepted solution]

Hi @Anonymous 

You can use the below Measure to filter your visual table.

Measure = 
INT( 
    NOT( 
        SELECTEDVALUE( 'Table'[Category] ) = "F" 
    ) 
)

 Please see the below for reference.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Thanks @Mariusz ! That helps 🙂