Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
May I request your advise for the following?
I have Start Date and End Date slicers that control the No of Day column in the table and the Sales per Day is calculated based on Sales/No of Day. After that the Salespersons will categorised into A, B or C based on the the three Min Category benchmark.
However, my end result I need to group the result by Category. Eg: in this case, C will have 2 salesperson and total of 160 sales; B will have 1 salesperson and total of 278 sales. How can I group the result since the category is a calculated measure based on the dynamic start and end date filter?
Appreciate your help. Thanks in advance!
Bryan
Solved! Go to Solution.
Hi,
You may download my PBI file from here. In the Category table, type in a very large number in the third column of Category A.
Hope this helps.
Hi,
Please share some data and show the expected result.
Hi Ashish Mathur,
Here you go. Thanks!
https://drive.google.com/drive/folders/1PKxQ9899BrvmEQ0odZjNRf2a9M7LtxRN?usp=sharing
Bryan
Hi,
You may download my PBI file from here. In the Category table, type in a very large number in the third column of Category A.
Hope this helps.
Hi Ashish Mathur,
Really thanks for your solution. It's work!
But what if my category benchmark is a SCD table? How do we deal with that?
https://drive.google.com/drive/folders/1PKxQ9899BrvmEQ0odZjNRf2a9M7LtxRN?usp=sharing
Warm Regards,
Bryan
You are welcome. If my previous reply helped, please mark it as Answer. For your new question, start a new thread.
Hi Ashish Mathur,
Here is the new thread. Thanks!
[Need Help]: How to join a table with Slowly Chang... - Microsoft Power BI Community
Warm Regards,
Bryan
@jiayit918871 , I think ABC is based on sales. This needs bucketing with an independent table.
You need to use the sales rep name with that to group and create new measures
Refer these two
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |