cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
alisoroush7
Frequent Visitor

categorize customer

hi guys,

i have data like the below table

customerdatesale
x07/18/202223,000 $
y07/15/202253,000 $
z07/10/202236,000 $
x02/22/202210,000 $
z05/17/202223,000 $

 

i have 2 rule that i want to implement it:

if total sale of a customer is less than 55,000 $ then label it as A

else label it as B

and finally i want to have a chart that shows me how many percent of my customers is labeled as A and B

how can i achieve this?

thanks.

1 ACCEPTED SOLUTION

@alisoroush7, yes it's possible. 
Please don't forget to accept the solution and will appreciate your Kudos on my solutions 🙂
Here is a link to download the file with the updated solution:
categorize customer 2022-07-20.pbix

View solution in original post

3 REPLIES 3
SpartaBI
Community Champion
Community Champion

@alisoroush7 
Here is a link to download the file with the solution:
categorize customer 2022-07-20.pbix


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

thank you for your respons. with this code my request has been satisfied 80%.

i have another issue. the issue is that i have a date filter. for example month. when i filter my dashboard in a specific month, i want that code to consider only the chosen month data and label the customer based on a chosen month. for example it is possible that one customer is labeled A in July but it is labeled B in March.

@alisoroush7, yes it's possible. 
Please don't forget to accept the solution and will appreciate your Kudos on my solutions 🙂
Here is a link to download the file with the updated solution:
categorize customer 2022-07-20.pbix

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors