Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ZachPLPI
Frequent Visitor

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 power BI.

 

I am trying to group my clients by sales over a period of time. For example, I want

 

Client                           Premium           

Fred's Donuts               $1000

Fred's Donuts               $5000

Sam's Auto                    $100

Eric's Dentistry              $10500

 

to show in a table as:

Client Group                Total

Clients < $500             $100 

Clients $500 - $2000   $6000

Clients > $10,000        $10,500

 

How can I do that? And will that total move dynamicly by page level date filters? For example, if Eric's Dentistry only has $600 in premium last year and I filter to last year at the visual level, will he move to the Clients $500 - $2000 group automatically?         

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

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"
)
Capture3.JPGCapture4.JPG
 
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I plugged this in a while back and it was still pulling premiums that were more or less than there assigned measure. Might there be a typo?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors