how to get sum based on group by columns in DAX measure

[Anonymous]

hi all,

    I'm using powerbi report server march 2018 desktop version with SSAS tabular model datasource.

i have a query to get sum of distinct values by country column. I have taken DAX to create measure as CALCULATE(SUM(table1[total number of contracts]),table1[Year]=2018,ALL(table1[Country]))))

but this is not giving me the proper result

i have table1 as :

and many rows like this for each country...

so, as my requirement is 

if i take country, SetUp/Set Down, Function in slicer and click Japan in country and AX in function & 2018 in year slicers then i should get only 60, but i'm getting 240 (its considering all questions also) .....how can i get sum of total number of contracts  as 60 using DAX?? 

pls help

thanx in advance..

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may refer to the measure below.

Measure =
SUMX (
    VALUES ( Table1[SetUp/Set Down] ),
    CALCULATE ( MAX ( Table1[total number of contracts] ) )
)