Ignore page filter in Measure but show all values not just the overall total

[CP_2024]

Hi all,

I am trying to ignore a page filter in one of my measures by using the formula below.

Type2 Cases =

CALCULATE(SUM('Table'[Total Case]),'Table'[Type] = "Type2",  ALL(Table[ColorName]))

The filter I want to ignore is the "color name"

But I get the grand total in all rows not the individual value.

Example of what I get:

I need to keep that measure static regardless if  the "color filter" changes.

Can someone please help me with this?

Thank you,

Maria

[v-yangliu-msft · Accepted solution]

Hi  @CP_2024 ,

I created some data:

You can try the following dax:

SUMX(
    FILTER('Table','Table'[Type]="Type2"),[Total Case])

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PijushRoy]

Hi @CP_2024 

Please use the REMOVEFILTER function which page level filter you want to remove.
Ref - https://learn.microsoft.com/en-us/dax/removefilters-function-dax
Please find the one example answer
https://community.fabric.microsoft.com/t5/Desktop/Static-and-dynamic-chart-in-same-visual/m-p/362734...

If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.

Thanks
Pijush
www.MyAccountingTricks.com 
https://www.youtube.com/MyAccountingTricks

[CP_2024]

Hi,

Thank you for your answer but I still get the same result

Type2 Cases =

CALCULATE(SUM('Table'[Total Case]),'Table'[Type] = "Type2", REMOVEFILTERS (Table[ColorName]))

[PijushRoy]

Hi @CP_2024 

Type2 Cases =

CALCULATE(SUM('Table'[Total Case]),'Table'[Type] = "Type2", ALL (Table[ColorName]))
make sure you are using Table[ColorName] filed in page filter

please confirm

[CP_2024]

Yes, using same column for both