Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Can you minus rows in a matrix visualisation?

Hi All,

 

Based on a dataset with 3 pivoted columns "Product", "date", "price" I created the following matrix. Both product 1 and product 2 (and others) have multiple rows in the imported dataset. So are not unique values. They are registered per sale. I created a matrix by putting product in the row, date in the columns and price in the values. This is exactly what I wanted to see. However, I also would like to see the result of prod 1 minus prod 2 for each month. If it is not possible in the matrix below I don't mind creating an extra one just for this. But I have no idea how to do this since the prices and product names are in the same column. This means a measure like AVERAGE(table[price]) - AVERAGE(table[price]) will not work, as this results in all 0's. 

 

commodity_check_0-1618575783554.png

So how can I see the result of prod 1 minus prod 2 for each month? 

 

Kind regards,

commodity_check

1 ACCEPTED SOLUTION

Syndicated - Outbound

@Anonymous , You will need one/two independent product table 

refer how this done for dates/period 

https://youtu.be/44fGGmg9fHI

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

Syndicated - Outbound

@Anonymous , You have to try a measure like

 

AVERAGEX(filter(allselected(Table[product]) ,Table[product] = "Prod 1") ,table[price]) - AVERAGEX(filter(allselected(Table[product]) ,Table[product] = "Prod 1") ,table[price])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user
Anonymous
Not applicable

Syndicated - Outbound

Hi @amitchandak ,

Would it be possible to make Product dynamic? Instead of typing "Prod 1"? I do have a unique key for every line. 

Syndicated - Outbound

Hi @Anonymous ,

 

Could you pls provide your expected output in details?

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Syndicated - Outbound

@Anonymous , You will need one/two independent product table 

refer how this done for dates/period 

https://youtu.be/44fGGmg9fHI

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)