Forum Discussion
Solved
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 clas...
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")
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")
