Forum Discussion

SM321's avatar
SM321
Frequent Visitor
2 years ago
Solved

Static values in card.

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?

 

  • 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's avatar
    Anonymous
    2 years ago

    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

     



2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
    Greg_Deckler
    Community Champion

    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.