The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Species | Plant | Type | Quantity | Hardiness |
holly | bush | leaf | 2 | 9 |
maple | tree | leaf | 3 | 9 |
iris | flower | bulb | 3 | 7 |
azelea | bush | leaf | 10 | 6 |
oak | sapling | seed | 6 | 6 |
wild | grass | seed | 8 | 5 |
ginko | tree | leaf | 5 | 4 |
golf | grass | seed | 3 | 3 |
oak | tree | seed | 3 | 3 |
rose | flower | bulb | 6 | 3 |
ginko | tree | seed | 4 | 2 |
maple | sapling | seed | 2 | 1 |
maple | bush | leaf | ||
iris | flower | leaf | ||
holly | bush | seed | ||
rose | bush | leaf |
Solved! Go to Solution.
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:
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: