Help with dax in a matrix

DAX DAX Calculations
1

Hi to all!, first time posting here :smiley:

I’m trying to do this in a matrix:

Image 1: This is the table that has the information that i have:

image
image1022×264 193 KB

Image 2: I want it to show the table like this in power BI:

image
image1018×301 28.5 KB

For example, in the image 2, the number that is inside the matrix in the row 4 (Product 4) with the column 1 (Product 1) is made like this: Sell Out Value Sales Product 4 (300,000) - Sell Out Value Sales Product 1 (200,000) = 100,000 and so on for each number in that row.

How can i do this? i want to analize the opportunities that have each product if i use one as a driver so the other one that has low sales could increase selling both at the same time. Also you can see the file here: https://transferxl.com/0029nyPrsFRVp

Hope u can help me :slight_smile:

Thank you all!

2

Welcome to the Enterprise DNA Forum @MiguelCruz . We’re happy to have you in the community. To get started, I highly suggest you check these guides that Sam created for us to build a more collaborative environment. How To Use The Enterprise DNA Support Forum

1 Like
3

If this helps, it should look like the tab in the excel i’m uploading that says “Should Look Like This in PBI”

Thanks :slight_smile: Matriz A.xlsx (67.3 KB)

4

Hi @MiguelCruz. Please upload your work-in-progress PBIX file for the forum members to use during their analyses. Also, if you include any DAX samples, please use the built-in formatter.
Greg
_eDNA Forum - Format DAX

5

Hi Greg!,

The thing is that i don’t know how to do it in PBI. I only know how to do in excel like the file i’ve uploaded.

Miguel

6

Anyone? :frowning:

7

Thanks for posting your question @MiguelCruz. To receive a resolution in a timely manner please make sure that you provide all the necessary details on this thread.

Here is a potential list of additional information to include in this thread; demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

Including all of the above will likely enable a quick solution to your question.

8

Hi @MiguelCruz, we’ve noticed that no response has been received from you since the 16th of November. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!