Static values in card.

[SM321]

Hello Experts,

I have few card values, those that are calculated measures, I want the values to be static / unchanged if there's any interaction or filters within the page. I tried using Edit interaction but it doesn't allow me doing that. What else I could possibly try to keep the values unchanged?

[Greg_Deckler · Accepted solution]

@SM321 Edit interacations will not account for filters in the Filters pane. You can potentially get around that by using ALL in your measures.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous · Accepted solution]

Hi @SM321 ,
Thanks for @Greg_Deckler  reply.
Next are my realizations and additions:
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create meaures

RemoveSlicers = 
CALCULATE(
    SUM('Table'[Value]),
    ALL('Table')
)

Remove filters = 
CALCULATE(
    SUM('Table'[Value]),
    ALL('Table'),
    REMOVEFILTERS('Table'[Value])
)

Final output

Best regards,

Albert He

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

[Greg_Deckler · Accepted solution]

@SM321 Edit interacations will not account for filters in the Filters pane. You can potentially get around that by using ALL in your measures.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.