Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hey Everyone,
I calculated ASP by dividing Column Revenue by Column Units...
I now want to group those ASPs into four groups as follows: A ($0-299), A ($300-499), A ($500-999), A ($1000+)...
Guidance on how to achieve this by another Measure or Calcualted Column or some other way greatly appreciated.
Thank you!
mibu
Solved! Go to Solution.
Hello @mibu ,
You can create a calculated column as DAX below.
Group ASP =
SWITCH (
TRUE (),
Table1[ASP] >= 0
&& [ASP] < 300, "A ($0-299) ",
Table1[ASP] >= 300
&& [ASP] < 500, "A ($300-499) ",
Table1[ASP] >= 500
&& [ASP] < 1000, "A ($500-999)",
Table1[ASP] >= 1000, "A ($1000+)"
)
NOTE: The .pbix link you shared cannot be opened.
Best regards
Amy
Community Support Team _ Amy
If this post helps,then consider Accepting it as the solution to help other members find it more quickly.
Hello @mibu ,
You can create a calculated column as DAX below.
Group ASP =
SWITCH (
TRUE (),
Table1[ASP] >= 0
&& [ASP] < 300, "A ($0-299) ",
Table1[ASP] >= 300
&& [ASP] < 500, "A ($300-499) ",
Table1[ASP] >= 500
&& [ASP] < 1000, "A ($500-999)",
Table1[ASP] >= 1000, "A ($1000+)"
)
NOTE: The .pbix link you shared cannot be opened.
Best regards
Amy
Community Support Team _ Amy
If this post helps,then consider Accepting it as the solution to help other members find it more quickly.
@mibu , refer SEGMENTATION/Binning
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bi...
https://www.credera.com/blog/technology-solutions/creating-aging-report-using-a-user-selected-date-i...
Thanks for your reply!
All following files on Dropbox:
Pls see dev .pbix file here
Pls see FactSales Excel file here
Pls see Dimpbdev Excel file here
What I am trying to achieve is a calculated column... grouping ASP into four groups... that I can then create a connection to in Dimpbdev.
Thanks in advance for your help!
Best,
mibu
User | Count |
---|---|
136 | |
70 | |
69 | |
54 | |
53 |
User | Count |
---|---|
207 | |
94 | |
64 | |
61 | |
57 |