Count number of occurrences of a measure

[Anonymous]

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.

Please, help me 😞

[kesha_shah135]

Use following measure:

Count = COUNT('Table'[Status])

Use this measure and Column "Status" as values in table visual.

[Jihwan_Kim]

Hi, @Anonymous 

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.

[Anonymous]

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.

[Jihwan_Kim]

Hi, @Anonymous 

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

[Anonymous]

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"

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

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

https://www.dropbox.com/s/ie1y3l4l68cbf9s/1092%20%281%29.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

[Jihwan_Kim]

Hi, @Anonymous 

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

[Anonymous]

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

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

could try again?