PNL by Account

[kelvin-lkhca]

Hi All,

I have created a measure and wish to achieve the something like illustrated below with the measure and matrix table,  

However, I can't get the same result as above table with the measure I have written which are shown in below. Can you please help to look into and advise how I can modify the Measure in order to achieve what I want? 

I have also shared the Excel file and PBI file with the link at the bottom.

Measure

Matrix Table

Raw Data

Account Mapping

https://drive.google.com/drive/folders/1XTp2ajb8ZnncG1YqdgvMIxfXfedQKdIe?usp=drive_link

[lbendlin]

access denied.  Where in your raw data do you indicate the expected sort order of your categories?

[kelvin-lkhca]

Hi @lbendlin ,

Sorry that forgot to change the access restriction previously. Please find below for the link.

Yes, there is one table in the PBI, shown as below, is used to sort the order of the categories.

Folder link

https://drive.google.com/drive/folders/1XTp2ajb8ZnncG1YqdgvMIxfXfedQKdIe?usp=sharing

Sample Data link

https://docs.google.com/spreadsheets/d/1s8CZ_6VxIsI69qJP5yxow17i1t4MlCgb/edit?usp=sharing&ouid=11057...

PBI Link

https://drive.google.com/file/d/1M6_Ue3A0aCJ_1yR4vXijeXfVAktt-Gri/view?usp=sharing

[lbendlin]

[kelvin-lkhca · Accepted solution]

@lbendlin  Awesome!! Thanks a lot!