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
Super User
Super User

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.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!