cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
henriquemalone
Helper II
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:

ColumnMeasure
OrderStatus
123456Blue
654789Blue
987564Blue
147852Red
365895Red
963254Yellow

 

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

Like this:

Blue3
Red2
Yellow1

 

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.

 

Please, help me 😞

1 ACCEPTED SOLUTION

Hi, @henriquemalone 

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.

 

Picture5.png

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.


Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

 


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

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

View solution in original post

8 REPLIES 8
kesha_shah135
New Member

Use following measure:

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

Hi, @henriquemalone 

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

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

Hello,

 

Heres the link:

https://drive.google.com/drive/folders/1HcMUlF0eddyPO6LA6XLgRR_mSwlsonSA?usp=sharing

 

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.

Hi, @henriquemalone 

Thank you for sharing.

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

Please check the link down below Page 1, whether I followed your request correctly.

 

https://www.dropbox.com/s/lw6zofbtwuxocs2/1092.pbix?dl=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.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM


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

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

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"

Hi, @henriquemalone 

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.

 

Picture5.png

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.


Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

 


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

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

View solution in original post

Hi, @henriquemalone 

 

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

 

Picture3.png


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

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

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

 

https://drive.google.com/drive/folders/1HcMUlF0eddyPO6LA6XLgRR_mSwlsonSA?usp=sharing

 

could try again?

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

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

R2 (Green) 768 x 460px.png

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.