Forum Discussion

JDartz's avatar
JDartz
Frequent Visitor
1 year ago
Solved

Distinct Count of Items From a Measurement

Hello, everyone!   I am trying to get a distinct count of items from a measurment in my data. I have created a measurement that gives indiivual locations a letter grade, as in the table below: ...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    If letter grade is a measure and not a calculated column, try this measure:

    COUNTROWS (
    FILTER (
        SUMMARIZECOLUMNS ( 'table'[location], "@letter grade", [letter grade measure] ),
        [@letter grade] = "A"
    )
)

     

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

If letter grade is a measure and not a calculated column, try this measure:

COUNTROWS (
    FILTER (
        SUMMARIZECOLUMNS ( 'table'[location], "@letter grade", [letter grade measure] ),
        [@letter grade] = "A"
    )
)

 

  • JDartz's avatar
    JDartz
    Frequent Visitor
    1 year ago

    This is was what I needed! Thank you!