Forum Discussion
Simple Count measure
Hi, I have 2 dog kennels with 10 spaces in Manchester and 3 in Edinburgh. What measure would tell me that any Location with over 6 kennels is classed as a "Large Kennel", and anything under 6 is classed as a "Small Kennel" please? Thanks!
| Location | Kennels |
| Manchester | M1 |
| Manchester | M2 |
| Manchester | M3 |
| Manchester | M4 |
| Manchester | M5 |
| Manchester | M6 |
| Manchester | M7 |
| Manchester | M8 |
| Manchester | M9 |
| Manchester | M10 |
| Edinburgh | E1 |
| Edinburgh | E2 |
| Edinburgh | E3 |
Hi RichOB ,
For that case Just assume >= to include 6 kernels, please see the updated DAX
Kennel_Size_Measure = VAR KennelCount = COUNT('Table'[Kennels]) RETURN IF(KennelCount >= 6, "Large Kennel", "Small Kennel")
5 Replies
Hi RichOB ,
You can create a DAX measure in Power BI to classify each location as either a "Large Kennel" or a "Small Kennel" based on the total number of kennels in each location. The measure counts the number of kennels per location and applies a condition where locations with more than 6 kennels are categorized as "Large Kennel" while those with 6 or fewer are labeled as "Small Kennel."
Kennel Size Classification = VAR KennelCount = COUNT('Table'[Kennels]) RETURN IF(KennelCount > 6, "Large Kennel", "Small Kennel")For example, in this dataset, Manchester has 10 kennels, so it will be classified as a "Large Kennel," while Edinburgh, with only 3 kennels, will be classified as a "Small Kennel." This logic ensures that locations are dynamically categorized based on the number of kennels they contain.
Best regards,
Thanks for this. It has given the output I need, but in my real-life scenario, when a location has 6 kennels it shows as blank. Do you know why this is, please?
Hi RichOB ,
Use this measure to achieve your goal:
Kennel_Size_Measure = VAR KennelCount = COUNT('Table'[Kennels]) RETURN IF(KennelCount > 6, "Large Kennel", "Small Kennel")Your Output will look like this:
Thanks for this. It has given the output I need, but in my real-life scenario, when a location has exactly 6 kennels it shows as blank. Do you know why this is, please?
Hi RichOB ,
For that case Just assume >= to include 6 kernels, please see the updated DAX
Kennel_Size_Measure = VAR KennelCount = COUNT('Table'[Kennels]) RETURN IF(KennelCount >= 6, "Large Kennel", "Small Kennel")
