How to keep one column constant irrespective of filters applied

[raimon]

Hi All, 

I have data like below - 

	India	UK	USA
Sports	5%	10%	3%
Education	5%	10%	3%
Health	5%	10%	3%

How do I ensure if country filter is selected, "India" is always shown.

[raimon]

@v-kkf-msft I am amazed by the solution. Thank you.

It feels so good to explore new things out there. Empowering to know what all is possible. 

[amitchandak]

@raimon , Add +0 to the measure or use this option

[raimon]

@amitchandak this is what I am looking for - 

1) 

2) 

3) 

[v-kkf-msft · Accepted solution]

Hi @raimon ,

Please create the following table.

Country = CALCULATETABLE ( DISTINCT ( 'Table'[Country] ), 'Table'[Country] <> "India" )

Then create measure:

Measure = 
COUNTROWS (
    INTERSECT (
        VALUES ( 'Table'[Country] ),
        UNION ( Country, {"India"} )
    )
)

And filter Country column by Measure.

Result:

  

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[Anonymous]

this is impressed!