Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I have datasets which has profit column and gaming account column. i Have to create a coulmn based on gaming account which will be a specfic range. For expample, suppose i have data like
Gaming Account Profit
A 500
B 200
A 200
C 500
A 300
C 800
Now, i want to group these customers like,
Customer Group Min- Profit Max Profit
Top Customer 1000 1500
OK Customer 500 1000
Small Customer 0 500
Now, Over here A's over all profit is 1000, so, he will be in to top customer group..B's profit is 200, so B is Small customer and C is again Top customer. So, my desired output will be,
Gaming Account Profit Account Segment
A 1000 Top customer
B 200 Small Customer
C 1300 Top Customer
I have tried this by following DAX way, but no luck..
Measure= CALCULATE([Total Profit],FILTER(VALUES('Profit'[Gaming Account]), IF( 'Profit'[Gross Gaming Revenue] <=500,"Small Customer",IF('Profit'[Gross Gaming Revenue]<=1000,"Ok Customer","Top Customer"))))
Can you please help me on that?? how to achieve this stage.
Any suggesation is really appreciable.
Thanks,
snandy2011
Solved! Go to Solution.
Hi,
Try these measures
[Total Profit]=SUM(Table1[Profit])
[Account Segment]=if(HASONEVALUE(Table1[Gaming Account]),if([Total Profit]>=1000,"Top Customer",if([Total Profit]>=500,"OK Customer","Small Customer")),BLANK())
Hope this helps.
Hi,
Try these measures
[Total Profit]=SUM(Table1[Profit])
[Account Segment]=if(HASONEVALUE(Table1[Gaming Account]),if([Total Profit]>=1000,"Top Customer",if([Total Profit]>=500,"OK Customer","Small Customer")),BLANK())
Hope this helps.
Thanks it works.. Thanks a lot..
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
104 | |
77 | |
71 | |
51 |
User | Count |
---|---|
146 | |
107 | |
106 | |
89 | |
65 |