View My Drafts
I have two tables are sale and Month.
In Month table contains item, month and qty and Month table has Month.
I added month table in slicer, I want to see sum of sale qty based on the sale qty and price in visualization table depends on the month selection in slicer.
I created calculate column but, I like to create one measure based on the Jun, Jul and Aug, so I can filter the result in visual.
For example –
If I selected the Jun in slicer, then it will show sum of sale qty
Sales Amount = SUMX(SALES, SALES[QTY] * RELATED(PRICES[PRICE]))
Then, a matrix visual using the "LIST" column from your MONTH table, and the "Sales Amount" measure should give you the results you want:Please let us know if that's what you wanted to achieve.Kaz.