Bracket or group

[Dk_bbr]

My english too bad hope can understand this.

I want my customers grouping by their sales. like this group is over 100M and this one is over 50M. like premium, gold, silver 

how did you do that writing DAX or?

[ryan_mayu · Accepted solution]

@Dk_bbr 

you can use SWITCH

https://learn.microsoft.com/en-us/dax/switch-function-dax?wt.mc_id=DP-MVP-5004616

Measure =

VAR _sales=sum('Table'[sales])

return SWITCH(TRUE(),_sales>300,"premium",_sales>100,"gold","silver")

pls see the attachment below

[Dk_bbr · Accepted solution]

but like it's all of them comes together , i want to see them separated.  likw this table only showes gold members. How can i calculate this?

gold members	sales
a	100
b	110
c	120

[Uzi2019]

Hi @Dk_bbr 
You can try with calculated column
Group =SWITCH(TRUE(),Sales>10000000,"Premium",Sales>5000000,"Gold","Silver")

I hope this is what you are lookin!

[ryan_mayu · Accepted solution]

@Dk_bbr 

you can use SWITCH

https://learn.microsoft.com/en-us/dax/switch-function-dax?wt.mc_id=DP-MVP-5004616

Measure =

VAR _sales=sum('Table'[sales])

return SWITCH(TRUE(),_sales>300,"premium",_sales>100,"gold","silver")

pls see the attachment below

[Dk_bbr · Accepted solution]

but like it's all of them comes together , i want to see them separated.  likw this table only showes gold members. How can i calculate this?

gold members	sales
a	100
b	110
c	120

[ryan_mayu · Accepted solution]

you can filter the data that you want