count distinct rows

[sea]

Hello,

I have these the tables:

How can I filter with two slicers (one for id_user and one for year) and generate the number of distinct cities?

Thank you!

[Zubair_Muhammad · Accepted solution]

HI @sea

Try this MEASURE

Measure =
CALCULATE (
    DISTINCTCOUNT ( Table_Customers[city_customer] ),
    SUMMARIZE (
        Table_Activities,
        Table_Activities[id_customer],
        Table_Customers[city_customer]
    )
)

[sea]

Work!

Thank you @Zubair_Muhammad