Forum Discussion
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
Anonymous , You will need one/two independent product table
refer how this done for dates/period
4 Replies
- amitchandak
Super User
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])
Hi amitchandak ,
Would it be possible to make Product dynamic? Instead of typing "Prod 1"? I do have a unique key for every line.
- amitchandak
Anonymous , You will need one/two independent product table
refer how this done for dates/period