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]
    )
)

2 Replies

  • 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]
    )
)