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
Munch00
Helper I
Helper I

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.

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


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