Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
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.
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?
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:
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |