Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Create categories based on a measure

Hello,

 

I'm pretty new to Power BI so forgive me if my question is obvious for you all. 

 

I have a table called CALLS and I'd like to create two categories based on measure values. 

 

My measure is the one below:

 

call_numbers = CALCULATE(DISTINCTCOUNT(CALLS[call_ID]), FILTER(CALLS, CALLS[sms] = "1"))
 
I'm trying with something like this but it doesn't work as it should:
 
Categories=
SWITCH(
    TRUE(),
    call_numbers > 1 && call_numbers <= 3, "1-3",
    call_numbers > 3 && call_numbers <= 4, "4",
    BLANK()
)
 
Format:
CALLS[call_ID] = text 
CALLS[sms] = text 

call_numbers = int number 

 

I'm afraid that the problem could be related to the filter. 

Is there someone who can help me? 

 

Thanks in advance 

 

Need Help