Forum Discussion

sea's avatar
sea
Frequent Visitor
8 years ago
Solved

count distinct rows

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!
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI sea

     

    Try this MEASURE

     

    Measure =
CALCULATE (
    DISTINCTCOUNT ( Table_Customers[city_customer] ),
    SUMMARIZE (
        Table_Activities,
        Table_Activities[id_customer],
        Table_Customers[city_customer]
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

HI sea

 

Try this MEASURE

 

Measure =
CALCULATE (
    DISTINCTCOUNT ( Table_Customers[city_customer] ),
    SUMMARIZE (
        Table_Activities,
        Table_Activities[id_customer],
        Table_Customers[city_customer]
    )
)
sea's avatar
sea
Frequent Visitor
8 years ago

Work!

Thank you Zubair_Muhammad