Find the count of a measure

[Aditi_R]

Hello everyone,

I need to calculate the count of the distinct remarks: "Above Expected", "As Expected" and "Below Expected" seen in the remarks column. But the remarks column is a Measure and hence the straightforward COUNT formula doesn't work.

An outcome something of the sort:

 is expected.

Or maybe a pie chart showing the distribution.

Any suggestions appreciated!

Thank You!

[MFelix · Accepted solution]

Hi @Aditi_R ,

Create a table with the Remarks values (inthis case I called it RemarkSelection) then try to adde following measure:

Values =
COUNTROWS (
    FILTER (
        ADDCOLUMNS ( DISTINCT ( Table[StudentID] ), "Remark", [remark_select] ),
        [Remark] in Values ( RemarkSelection[Remark] )
    )
)

[Aditi_R]

Thanks a lot. It is working great!