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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
MulberyPie
Advocate I
Advocate I

Counting and displaying entry occurrence

I want to keep a list of the appearances of a number in a data set. I'm trying to figure out the best way to collect and display the data. I've given a table with values. If I was sorting by type I would want to record how many times a number shows up the in the data set. I could show this in a table but that feels repetitive. Is there a better way to show this data, and would I use the COUNT function to record how many times a number appears?

 

# - how many entries

MulberyPie_0-1654548027345.png

 

 

 

 

 

 

SpeciesPlantTypeQuantityHardiness
hollybushleaf29
mapletreeleaf39
irisflowerbulb37
azeleabushleaf106
oaksaplingseed66
wildgrassseed85
ginkotreeleaf54
golfgrassseed33
oaktreeseed33
roseflowerbulb63
ginkotreeseed42
maplesaplingseed21
maplebushleaf  
iris flower leaf  
hollybushseed  
rosebushleaf  
1 ACCEPTED SOLUTION
johncolley
Solution Sage
Solution Sage

Hi @MulberyPie ,

 

A simple count measure wil ldo the trick:

Hardiness Count = COUNT(Plants[Hardiness ])

Plenty of ways to show this information depending on your reuirement, some examples below:

johncolley_0-1654560054360.png

 

 

 

View solution in original post

1 REPLY 1
johncolley
Solution Sage
Solution Sage

Hi @MulberyPie ,

 

A simple count measure wil ldo the trick:

Hardiness Count = COUNT(Plants[Hardiness ])

Plenty of ways to show this information depending on your reuirement, some examples below:

johncolley_0-1654560054360.png

 

 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors