Hi, I’m looking to create a table of sales figures by supplier to shop. eg:
Supplier Name | Product Type | Shop A $ | Shop B $ | Shop C $ | Shop D $
I’m unsure how to tackle this. My thinking is to:
CALCULATE (SUM(Sales [Deliveries] ,
Products [Type] = “Plastic”,
Retail Outlets [Shops] = “Shop A”
Would this be the correct approach? I’m experimenting while asking this question.
Thanks All.
Hi @Dplex,
Hard coding the Product type and/or Shop name, will probably mean a lot of measures to create and a report to contigniously update when a new store or product type is added…
Instead try to use the context from a visual to your advantage and a base measure:
Sales =
SUM(Sales [Deliveries] )
In a Matrix visual with Suppliers on the Rows and Product type + Shop on Columns or swap things around if that makes more sense like; Supplier + Product type on the rows and Shop on Columns.
I hope this is helpful
Hi Melissa, Thanks, you are completely correct. I just discovered a separate shop filter was causing that shop to miscalculate against the others distorting the total sales. All good now. Cheers.