Count and sum of multiple market models

[Anonymous]

So I need to do a count & sum on models that are present in mutliple markets. 

For example: 

I tried creating a measure without ALL to remove the filters, and based on that doing the count/sum, but it seems I'm still missing.  Does anyone have any guidance on how to resolve this? 

[Anonymous · Accepted solution]

Solution: 

Test =

VAR countryModel =

FILTER(

SUMMARIZECOLUMNS(

'Model'[Model],

"Count", DISTINCTCOUNT('Model'[Country])

),

[Count] > 1

)

VAR Result = IF( ISBLANK(COUNTROWS(countryModel)),"No Matches Found",COUNTROWS(countryModel))

RETURN Result

Test2 =

VAR countryModel =

FILTER(

SUMMARIZECOLUMNS(

'Model'[Model],

"Count", DISTINCTCOUNT('Model'[Country])

),

[Count] > 1

)

VAR Result =

CALCULATE(

SUMX(

'Model',

[Sales volume]),

FILTER(

countryModel,

[Model] = 'Model'[Model]

)

)

RETURN Result

Test3 =

VAR Result = COUNTROWS('Model')

RETURN Result