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

AndresEsteban my bad please create a measure as below:-

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

 

 

AndresEsteban's avatar
AndresEsteban
Helper I
4 years ago

Thank so much, it's work perfetly!!