Forum Discussion

Frequent Visitor

6 years ago

Sales Stratification/Grouping

I have searched all over for this answer but I cannot find it. It seems this would be a pretty popular command, though and my lack of knowledge in this area is probably due to my experience with powe...

Need Help

Tutorial Requests

v-juanli-msft

Community Support

6 years ago

Hi ZachPLPI

Create measures

Measure = CALCULATE(SUM('Table'[premium]),FILTER(ALLSELECTED('Table'),'Table'[client]=MAX('Table'[client])))

Measure 2 =
SWITCH (
    TRUE (),
    [Measure] < 500, "<500",
    [Measure] >= 500
        && [Measure] < 2000, "500~2000",
    [Measure] >= 2000
        && [Measure] < 10000, "2000~10000",
    [Measure] > 10000, ">10000",
    "other"
)