How to make a static column for the table?

[Anonymous]

Hello! I have a slicer with the region names and table which sums up data from regions.

Now, I want to make it in such a way that if the slicer selected, then only the Region column values change, country column values must be static (to compares with the region and country values )for all region changes. How can I do that?

[Shishir22]

Hello @Anonymous,

Can you please try using measure with ALLEXCEPT?

Something like-

Country= Calculate(Sum(table[values] ), allexcept(table, table[region])

Thanks! 

[Anonymous]

@Shishir22 what if I have to columns: one for country and another is regions with values?

[ryan_mayu]

@Anonymous 

Do you mean that you have 4 regions? and no matter what region you choose, you want to show all country's value?

Could you please provide the expected output in details?

[Anonymous]

@ryan_mayu 

I have data for regions and for the country(total of regions). I want to make a dynamic region column, while the country column has to be static. With this, users can see the difference between region and country. So, the region column has to change, while the country column has to be static. 

When the region not selected within the slicer, both columns have to be equal, but when selected, the region column has to show appropriate values for the selected region. 

I selected the region from slicer, data in the table changed, but I want to be country column to be static.

[ryan_mayu]

@Anonymous 

have you tried remove remoefilters

something like:

calculate([country measure],removefilters....)

https://docs.microsoft.com/en-us/dax/removefilters-function-dax

[Anonymous]

@ryan_mayu What if I have column country instead of measure?

[ryan_mayu]

@Anonymous 

if it's in the same table visual, i think you need to create a measure. If not, you can change visual interact

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

[Anonymous]

@ryan_mayu I have two different columns in one table as: Table[Region], Table[Country]

[ryan_mayu]

@Anonymous 

then I think you need to create a measure for the country value.

[Anonymous]

@ryan_mayu how should I create that? I mean the equation

[ryan_mayu · Accepted solution]

@Anonymous 

Please see the attachment. Hope it is helpful.