Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Aditi_R
Frequent Visitor

Find the count of a measure

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.

image.pngAn outcome something of the sort:

Aditi_R_0-1690454233527.png is expected.

Or maybe a pie chart showing the distribution.

 

Any suggestions appreciated!

Thank You!

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
MFelix
Super User
Super User

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

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Thanks a lot. It is working great!

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors