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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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, @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.

 

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 accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


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, @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.

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


Go to My LinkedIn Page


Anonymous
Not applicable

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, @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

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


Go to My LinkedIn Page


Anonymous
Not applicable

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, @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.

 

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 accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Hi, @Anonymous 

 

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

 

Picture3.png

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


Go to My LinkedIn Page


Anonymous
Not applicable

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.