[URGENT. NEED HELP] How to Turn a Measure into Column for Aggregation?

[jiayit918871]

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

[Ashish_Mathur]

Hi,

Please share some data and show the expected result.

[jiayit918871]

Hi Ashish Mathur,

Here you go. Thanks!
https://drive.google.com/drive/folders/1PKxQ9899BrvmEQ0odZjNRf2a9M7LtxRN?usp=sharing

Bryan

[Ashish_Mathur · Accepted 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.

[jiayit918871]

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

[Ashish_Mathur]

You are welcome.  If my previous reply helped, please mark it as Answer.  For your new question, start a new thread.

[jiayit918871]

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

[amitchandak]

@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