Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Migscruz
Helper I
Helper I

Help with dax table

Hi to all! i'm new at the forum  🙂

 

This is my data and the filters should be brand, sub brand, product family, sector and month:

Migscruz_0-1605212329354.png

 

And i need to look like this  in a matrix:

Migscruz_1-1605212386817.png

The formula por example in the row of product 4 is: Sales product 4 (300,000) - sales product 1 (200,000) = 100,000 and so on for each one.

 

How can i do this? The file is here Data example Thanks to all 🙂

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

create a reference copy of your data table in Power Query, then link both tables via the product name, and then create a measure that uses a CROSSFILTER(,,none) pattern

 

lbendlin_0-1605565360123.png

 

View solution in original post

2 REPLIES 2
v-jayw-msft
Community Support
Community Support

Hi @Migscruz ,

 

Has the problem be solved? Please consider mark the answer as solution if it works for you.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
lbendlin
Super User
Super User

create a reference copy of your data table in Power Query, then link both tables via the product name, and then create a measure that uses a CROSSFILTER(,,none) pattern

 

lbendlin_0-1605565360123.png

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.