- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
So how can I see the result of prod 1 minus prod 2 for each month?
Kind regards,
commodity_check
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous , You will need one/two independent product table
refer how this done for dates/period
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @amitchandak ,
Would it be possible to make Product dynamic? Instead of typing "Prod 1"? I do have a unique key for every line.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous , You will need one/two independent product table
refer how this done for dates/period

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
06-14-2024 06:54 AM | |||
12-03-2024 12:30 AM | |||
10-28-2024 06:07 PM | |||
11-28-2024 10:35 AM | |||
12-17-2024 05:44 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |