Forum Discussion

AndresEsteban's avatar
AndresEsteban
Helper I
4 years ago
Solved

Distinct count filtering by other column

Hello community I would need your help.   I have a table with the following records: -Device: are different types of devices and sensors. -Type of service: different types of services. Each devic...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    AndresEsteban my bad please create a measure as below:-

    Measure =
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[Type of service],
        "sum", DISTINCTCOUNT ( 'Table'[Location] )
    ),
    [sum]
)

     

     

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi AndresEsteban ,

 

You can directly add "Type of service" column and "location" column with summerized as distinct count on the table visual.

output:-

 

Refer the attached file.

BR,

Samarth

  • AndresEsteban's avatar
    AndresEsteban
    Helper I
    4 years ago

    Perfect, it works!!

     

    And another question, how could I calculate the total number of deployed services, in this case 7?

     

    Thank you

      • AndresEsteban's avatar
        AndresEsteban
        Helper I
        4 years ago

        but the result should be 7 not 13. It would have to be done through a DAX measure.