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

Count no. of occurrences in a visual column

Hi All

 

Can anyone help with this issue? Been searching for sometime but still cant find an answer.

 

So I generated below visual using measures. I need to count the no. of occurences of "Within range", "Overperform" and "Underperform" in the range column for below visual.

 

I tried to use fomulas like COUNT, but it seems that i need to reference to a column in a physical table, or some calculated column( which i cant add to the raw data as calculations would not work)

 

Is there any way to count from this visual directly?

 

Munch00_0-1663958900267.png

Appreciate if anyone can advise.!

1 ACCEPTED SOLUTION

Hi,

These measures work

Measure = COUNTROWS(FILTER(VALUES(data[SKU]),[Range]="Within range"))
Measure 3 = COUNTROWS(FILTER(VALUES(data[SKU]),[Range]="Underperform"))
Measure 2 = COUNTROWS(FILTER(VALUES(data[SKU]),[Range]="Overperform"))

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

7 REPLIES 7
Ashish_Mathur
Super User
Super User

Hi,

Share the download link of your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur 

 

Hi, i created a sample data. You can download from below link

sample pbix file 

 

Many thanks for helping. 

Hi,

These measures work

Measure = COUNTROWS(FILTER(VALUES(data[SKU]),[Range]="Within range"))
Measure 3 = COUNTROWS(FILTER(VALUES(data[SKU]),[Range]="Underperform"))
Measure 2 = COUNTROWS(FILTER(VALUES(data[SKU]),[Range]="Overperform"))

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur  Yes, it works! Thanks very much!!😊

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
parry2k
Super User
Super User

@Munch00 what is Range? Is it a measure or a column?

 

 

Follow us on LinkedIn and YouTube.gif to our YouTube channel

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





@parry2k 

Hi, it is the name of a measure. I created a sample file to illustrate what i need, you can refer to below link

sample pbix file 

 

Munch00_0-1664015736537.png

Many thanks!

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.