Power BI Group display both total and subcategory

[kkwang]

Hi, I have a dashboard like this, what I want is that for the #Turnovers by city column, it will return the city total

E.g. for city Beauport, the #Turnovers by City should all have 37 in each row. 

what I have now is: 

what I want is :

The measure I used is: 

#Turnovers by City =

var one_year_filter = FILTER('Table', DATEDIFF('Table'[start.date],TODAY(),MONTH) >=0 && DATEDIFF('Table'[start.date],TODAY(),MONTH) <= 12)                                                                                                    

var two_year_filter = FILTER('Table', DATEDIFF('Table'[start.date],TODAY(),MONTH) >=0 && DATEDIFF('Table'[start.date],TODAY(),MONTH) <= 24)  

return

IF(ISBLANK(SWITCH(SELECTEDVALUE('Passing Month'[Value]),

"Last 12 Months",CALCULATE(COUNT('Table'[number]), ALL(DIMENTION[City]),one_year_filter),        

"Last 24 Months",CALCULATE(COUNT('Table'[number]), ALL(DIMENTION[City]),two_year_filter),

CALCULATE(COUNT('COUNT('Table'[number]), ALLEXCEPT(DIMENSION,DIMENSION[City]))

)),blank(), SWITCH(SELECTEDVALUE('Passing Month'[Value]),

"Last 12 Months",CALCULATE(COUNT('Table[number]), ALL(DIM_RE_HIERARCHY[City]), one_year_filter),        

"Last 24 Months",CALCULATE(COUNT('Table[number]), ALL(DIM_RE_HIERARCHY[City]), two_year_filter),    

CALCULATE(COUNT('Table'[Number]), ALLEXCEPT(DIMENSION,DIMENSION[City]))

)

)

--------------------------

can someone kindly take a look help me fix it? thanks so much in advance!!!

[Gabry]

try sumx of your #Turnovers by City  measure over dim(city) table

[kkwang]

Hi Gabry,

I tried to revised the measure to 

"Last 12 Months",CALCULATE(SUMX(Table, 'Table'[number]), ALL(DIMENTION[City]),one_year_filter),        

"Last 24 Months",CALCULATE(SUMX(Table,, 'Table'[number]), ALL(DIMENTION[City]),two_year_filter),

but it doesn't work..

[Gabry]

nope I meant a new measure = sumx(your prev measure, dimtable).

Couldn't you upload the pbix with sample data?

[kkwang]

Hi Gabry, I tried to use the sumx to create a new measure.. but it's still not wokring..

I am sorry, but the data is confidential, I could not post it online due to the policy.

but still thanks for your help!!