How to calculate a sum depending on only one filter ?

[Gwendaline_p]

Hi ,

Here is an example of what I want :

I have the number of purchases by month and by country.

I have two filters : by month and by country.

I choose a month (January 2016) and a country (France) and I want to calculate the sum of purchases for France in January 2016 divided by the sum of purchases for all countries in January 2016.

Month	Country	Purchases
January 2016	France	150
January 2016	Italy	100
January 2016	Belgium	250

Result : 150 / (150 + 100 + 250) = 30 %

How can I do it please ?

Thanks for your help !

Gwendaline

[Vvelarde · Accepted solution]

hello @Gwendaline_p

please try with this dax measure.

Insert in a card visual

% =
DIVIDE (
    CALCULATE ( SUM ( Table1[Purchases] ) ),
    CALCULATE ( SUM ( Table1[Purchases] ), ALL ( Table1 ) ),
    0
)

[Gwendaline_p]

It works perfectly.

Thank you,

Gwendaline