How to show numbers in number card as static

[Mohsen_2020]

Hi Team, 

I created a simple measure calculating total sales for all countries and it's working perfect after putting in a number card but i want to be a static number as it's changing everytime i am clicking on any country on the map located in the same report, please advise. 

Regards,

Mohsen 

[amitchandak]

@Mohsen_2020 . Either create the meausre like

calculate([total minute spend],all(country))

or

stop ineraction -https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

[Greg_Deckler]

@Mohsen_2020 - Either use ALL in your measure used in your Card visual or use Edit Interactions on the View menu to disable interactions between other visuals and your card visual.

[Mohsen_2020]

Please help to adjust the code to make it static, code is showing below:

Total Minutes Spent YTD =

SUM('Calls_Per_MD'[Total Effective Meeting Duration])

Regards,

Mohsen

[Tahreem24 · Accepted solution]

Try this:

Total Minutes Spent YTD =

CALCULATE(SUM('Calls_Per_MD'[Total Effective Meeting Duration]), ALL(Calls_Per_MD))

[Mohsen_2020]

@Tahreem24 , Amazing! it's working Perfect and many thanks for your help.

Regards,

Mohsen

[Tahreem24]

Glad that my solution worked for you. 

Good Luck Mohsen!