Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
SM321
Frequent Visitor

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?

 

Test_.png

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

@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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

v-heq-msft
Community Support
Community Support

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:

vheqmsft_0-1712739568659.png

Create meaures

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

Final output

vheqmsft_1-1712739767046.png

vheqmsft_2-1712739780721.png

 

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

 



View solution in original post

2 REPLIES 2
v-heq-msft
Community Support
Community Support

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:

vheqmsft_0-1712739568659.png

Create meaures

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

Final output

vheqmsft_1-1712739767046.png

vheqmsft_2-1712739780721.png

 

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
Super User
Super User

@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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.