Forum Discussion
Help with setting up pricing table
Hi,
I want to create an interactive pricing table where it automatically calculates the amount of devices in each category and then show the total price per category and the overall total price.
The number of devices can be taken from the current Microsoft intune source, however i do not have anything in place concerning the pricing.
What would be the best way to start building this pricing table in Power BI?
See the table as an example:
| Number of devices | 3000 | Amount | |||
| 0-400 | € 6,00 | 400 | € 2.400,00 | ||
| 400-1000 | € 5,00 | 600 | € 3.000,00 | ||
| 1000-1500 | € 4,00 | 500 | € 2.000,00 | ||
| 1500-2500 | € 3,00 | 1.000 | € 3.000,00 | ||
| 2500-3500 | € 2,00 | 500 | € 1.000,00 | ||
| 3500-hoger | € 1,00 | 0 | € - | ||
| Total price | € 11.400,00 |
3 Replies
Anonymous , what is based data for it? Can you share sample data and sample output in table format?
I think you are looking for binning/segmentation
https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
https://youtu.be/CuczXPj0N-kamitchandak thank you for your reply, the data concerning the price categegory is a fixed data set. Probably will be an Excel sheet that shows the category and the corresponding price.
The amount of active devices will be extracted from Microsoft Intune, and will be counted based on some filters that i will define in the report. it indeed seems like dynamic segmentation, i will have a look into those articles and see if i can get this data to work.
Hi Anonymous ,
What is the number of devices in the table? Does it connect to category in data table? There are two "Amount" in the table, what are they and how do you get them? Please show some sample data to us.
You could check the topic about how to get you question answered quickly.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Best Regards,
Jay
