Simple Count measure

[RichOB]

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

[Bibiano_Geraldo]

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:

[RichOB]

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?

[Bibiano_Geraldo · Accepted solution]

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")

[DataNinja777]

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,

[RichOB]

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?