Select value from a column based on another column's value, and make it oblivious to user clicks

[Anonymous]

I have only one table containing several cities for which I use a slicer, and several revenue categories that I use in various visualizations and smart narrative cards. Every city is listed five times in my data.

Here is what my data table looks like. How do I select and only this:

The value of Municipal GDP Total where GDP Domain is "Culture Total"

I am currently using the formula below, but the problem is that if a user clicks on a segment of a pie chart, the total changes.

VAR _total = CALCULATE(SUM('infoGDP2010'[Municipal GDP Total]),FILTER('infoGDP2010','infoGDP2010'[GDP Domain]="Culture Total"))

[Anonymous]

Thank you @Anonymous and @lbendlin but my issue remains unchanged.

Below are screenshots to show what is happening. When the user clicks a category, the gdp number should not be affected; in this example it should remain 39.89 M$.

At the moment, the only way I have found to prevent user interaction from changing that number is to place a transparent rectangle on top of the entire region I wish to be click-disabled. It feels like a clunky workaround which is why I am looking for a solution involving dax code or powerbi features. 'Edit interactions' is not an option because my total dgp number is a smart narrative card and is not linked with 'Edit interactions'.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Anonymous]

Here is a sample pbix file and the table data.
If you click on a category - etiher on the donut chart or one of the labels on the right - the total should not change.

Currently, the dax formula will display 'Error: a category is selected' if you click on a category.

City	Province	Per Capita	Salary 2016	Year	Data Type	GDP Domain	Municipal GDP Total	Jobs Domain	Municipal Job Total	Provincial GDP	Provincial Jobs	Provincial GDP Rounded	Provincial Job Rounded
Ouagadougou	Kadiogo	3621	48,477	2020	Top 3 Domains_1	Audio	604598859	Audio	5288	28195529000	269034	28.2 B	269 K
Ouagadougou	Kadiogo	3621	48,477	2020	Top 3 Domains_2	Visuals	443556842	Visuals	4919	28195529000	269034	28.2 B	269 K
Ouagadougou	Kadiogo	3621	48,477	2020	Top 3 Domains_3	Written	321891340	Written	4106	28195529000	269034	28.2 B	269 K
Ouagadougou	Kadiogo	3621	48,477	2020	Other Domain Total	Other domains	868622979	Other domains	8382	28195529000	269034	28.2 B	269 K
Ouagadougou	Kadiogo	3621	48,477	2020	Culture Total	Culture Total	2238670018	Culture Total	22698	28195529000	269034	28.2 B	269 K
Ouagadougou	Kadiogo	3621	48,477	2020	Proportion of Provincial	Proportion of Provincial	7.94	Proportion of Provincial	8.44	28195529000	269034	28.2 B	269 K
Kuala Lumpur	Senlangor	3348	59,888	2020	Top 3 Domains_1	Audio	382915284	Audio	3205	28195529000	269034	28.2 B	269 K
Kuala Lumpur	Senlangor	3348	59,888	2020	Top 3 Domains_2	Visuals	258501841	Visuals	2255	28195529000	269034	28.2 B	269 K
Kuala Lumpur	Senlangor	3348	59,888	2020	Top 3 Domains_3	Written	201500527	Written	2173	28195529000	269034	28.2 B	269 K
Kuala Lumpur	Senlangor	3348	59,888	2020	Other Domain Total	Other domains	2221232802	Other domains	19652	28195529000	269034	28.2 B	269 K
Kuala Lumpur	Senlangor	3348	59,888	2020	Culture Total	Culture Total	3064150456	Culture Total	27286	28195529000	269034	28.2 B	269 K
Kuala Lumpur	Senlangor	3348	59,888	2020	Proportion of Provincial	Proportion of Provincial	10.87	Proportion of Provincial	10.14	28195529000	269034	28.2 B	269 K

[lbendlin]

Did you mean to link to the pbix ?

[Anonymous]

I've edited my previous message with this link to the pbix file :

https://drive.google.com/file/d/1hRcdILqbfPbMHG8mDFZp_gXVJ3NhHrvZ/view?usp=sharing

[Anonymous]

Hi @Anonymous ,

Please have a try.

f =
CALCULATE (
    SUM ( 'infoGDP2010'[Municipal GDP Total] ),
    FILTER ( 'infoGDP2010', 'infoGDP2010'[GDP Domain] = "Culture Total" ),
    ALLSELECTED ()
)

The allselected()  function will ignore any filters applied by the user, including slicers, and return the total value for the selected context .

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[lbendlin]

read about REMOVEFILTERS()