sum of values which are not filtered even making selection 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.




I have slicer based on the Name country, I need to find out the amount which is contributed by customer country.
The amount we are getting when we unselect the country with the help of DAX 

Total of unselected countries =

CALCULATE (

SUM(Country[Amount]),

FILTER (

Country,

Country[Client Country]

IN EXCEPT (

ALL ( Country[Name of country] ),

ALLSELECTED ( Country[Name of country] )

)

)

)

But We want that amount when we select the country in the slicer.

For Example : If we unselect Australia in the slicer, we will get the amount in the card but I need the same amount when we select australia in the slicer.

[Ashish_Mathur]

Hi,

In another card visual, drag this measure

Measure = SUM(Country[Amount])

Hope this helps.

[Anonymous]

But that will give me the sum of selected country , which is Australia in this case instead I want to show sum of country's in reverse.

Scenario: If we are selecting a country in the slicer the card visual will show sum of selected country's, with the measure above we can see we have the sum of countries when they are not selected in the slicer.

I want to show the value of unselected country's when making selection of that country.

Problem statement: we have data country and each country is having its own client countries, we want to calculate the sum which contributed by client country individually.

e.g. If country is Australia and it's client countries are Argentina, Australia, Spain. Calculate sum of Australia individual.

[Ashish_Mathur]

Have not understood a thing at all.  I am sure someone will and that person will surely help you.