Looking for sum of values which are not filtered in the slicer.

[shivendr]

Hi, 
I have data in one Table, which is having  3 columns which i need to use.
1. Name of Country's 
2. customer countries
3. Amount in dollars.

Country has more than one customer country including parent country.


I have slicer based on the Name country, I need to find out the amount which is contributed by customer country, when slicer is not selecting the particular country.

For example : If name country is columbia than its customer countries is Argentina, Columbia , maxico and so on, If I select all the countries in the slicer excluding Columbia, I want to know how much columbia's amont when not selected in the slicer.

I Created a measure to get all the countries which is not selected in the slicer by the following DAX: 

Measure =

VAR A =

CONCATENATEX (

FILTER (

ALL (Name of Country),

NOT' Name of Country'

IN VALUES ( Name of Country )

),

'Name of Country, ","

)

Return (A)

This is giveng me names of the countries which are not selected in the slicer but in single row, I need a solution of this problem.
Help me,
Thanks in advance

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[shivendr]

I can't share the file

[Ashish_Mathur]

Hi,

Please find attached the PBI file.

[shivendr]

Hi Ashish, Appreciate your effort and support, But this is not desired solution.
Please refer the screenshot

[Ashish_Mathur · Accepted solution]

Hi,

Refer to the attached file.

Hope this helps.

[shivendr]

Thank you Ashish, Great Work!

[Ashish_Mathur]

You are welcome.