How to build matrix table with custom names?

[Anmolgan]

I want to add 2 more values inside my mapping table. basically I have attached the powerbi file that I am using to build the mapping, if you see the page "Sales Group Totals", I want to add 2 more items there as Marine Domestic and Marine Export, now in order to simplify things I have written DAX as to where I am trying fetch these details from, I just want too see 3 metrics as per these 2 items too, but i could not get a way to do this, can anyone suggest me a way to add those 2 items here so that i can see Marine Domestic and marine export regarding the 3 metrics that are present there (Billed Quantity, Billed Value, Net Realization). 

DAX measures name for marine domestic and marine export, MDomestic, MExport.

PowerBI File: https://ifitech-my.sharepoint.com/:u:/g/personal/anmol_ganju_ifi_tech/ERcA8Cx01oVKugtMH0bRiAEB5Cw2-J...

[v-joesh-msft]

Hi @Anmolgan ,

I'm a little confused by your description.Could you share the screenshot of your desired output?

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anmolgan]

If you see page no 3 (Sales Group Total), I need to have same output with two extra fields (Marine Domestic) and (Marine Export). can it be possible?

[v-joesh-msft]

Hi @Anmolgan ,

I'm not sure if I understand what you mean, see if the following method is the result you expect:
1. Create a new table and establish a relationship with the table "Master Sales Report":

Table = UNION( DISTINCT('Mapping'[Sales Group]),{"MDomestic","MExport"})

2. Create the following three measures to replace the three measures of "Values" in the matrix:

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EX8SosUvyOdChdmfyc...

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anmolgan]

The value coming for MDomestic and MExport is not validating as the below should be result of the following:

MDomesticSales(KL): 331.54
MDomesticNetReal: 295.63

MExport(KL): 83.27

MExportNetReal: 85.79

I need to see above breakdown in the PowerBI file that you have posted, above is only for November 2019.