cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
provoke Frequent Visitor
Frequent Visitor

Count of Each Value & Total

Hi Guys,

 

In the below screenshot I'm not able to count the amount of times a human error, machine error (indicated by (x) ) etc, occurs at the different Locations & total is so I'm able to put in a pie chart & bar chart. Please help, thank you in advance. 

 

 

 

Screenshot (3).png

3 REPLIES 3
dilumd Established Member
Established Member

Re: Count of Each Value & Total

Hi,

 

Take a duplicate of your table and you can unpivot your table in power query and then remove blank and you can use that table to create a pie chart.

 

11.png22.JPG

provoke Frequent Visitor
Frequent Visitor

Re: Count of Each Value & Total

@dilumd this method does not give accurate results, I have tried this before. Need to figure out how to accuratley count so results are not skewed. 

Community Support Team
Community Support Team

Re: Count of Each Value & Total

Hi @provoke,

 

@dilumd's method is accurate. We can see it if we open the data label. Or you could use this measure.

 

Number =
COUNT ( Table1[Value] )

Count of Each Value & Total.jpg

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.