cancel
Showing results for
Did you mean:
Helper II

## Count number of occurrences of a measure

Hello,

I am a beginner and am learning on my own and I really appreciate all the great knowlegde and support here.

Well, i have the following table:

 Column Measure Order Status 123456 Blue 654789 Blue 987564 Blue 147852 Red 365895 Red 963254 Yellow

I need create a way to calculate the number of occurrences of MEASURE Status

Like this:

 Blue 3 Red 2 Yellow 1

I saw a lot of ways to do it but all of them is considering a column e not a measure like the way I need.

I believe its simple but i dont know how to do it.

1 ACCEPTED SOLUTION
Community Champion

Thank you for sharing.

In order to create one measure, I suggest creating a table like below.

Please check the below picture and the sample pbix file's link down below.

Count Statuss Measure V2 =
COUNTROWS (
FILTER (
VALUES ( 'Base CL 10052021'[PL] ),
[Statuss] = SELECTEDVALUE ( StatussMeasureCount[Result] )
)
) + 0

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

8 REPLIES 8
New Member

Use following measure:

Count = COUNT('Table'[Status])
Use this measure and Column "Status" as values in table visual.

Community Champion

Please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate solution.

Thanks.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Helper II

Hello,

I want to count the measure "Statuss" from the table "Base CL 10052021"

I need to know how many "Alocado", "Sem Remessa", "Cancelado" and "Faturado" there are in the table.

Community Champion

Thank you for sharing.

I assume the table name is BaseCL and the column you want to apply the status measure is [PL] column.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Helper II

Sorry but it didnt work for me.

I was trying create one single measure to do it.

Like a COUNTROW(Status)

But Statuss ir a measure so i cant use the formula dax this way.

Note: the measure Statuss is on the table "Base CL 10052021"

Community Champion

Thank you for sharing.

In order to create one measure, I suggest creating a table like below.

Please check the below picture and the sample pbix file's link down below.

Count Statuss Measure V2 =
COUNTROWS (
FILTER (
VALUES ( 'Base CL 10052021'[PL] ),
[Statuss] = SELECTEDVALUE ( StatussMeasureCount[Result] )
)
) + 0

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Community Champion

I cannot see the table name "Base CL 10052021" from your file.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Helper II

Sorry, i guess i didnt save the file before upload it.

could try again?

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

#### Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors