同问,不能拖进维度,在聚合度量里
CASE
WHEN [店均销售额] >= 100000 THEN '>10万'
WHEN [店均销售额] >= 80000
AND [店均销售额] < 100000 THEN '8-10万'
WHEN [店均销售额] >= 60000
AND [店均销售额] < 80000 THEN '6-8万'
WHEN [店均销售额] >= 40000
AND [店均销售额] < 60000 THEN '4-6万'
WHEN [店均销售额] >= 20000
AND [店均销售额] < 40000 THEN '2-4万'
ELSE '<2万'
END |