Filter Values in DAX

[ahmedismailfourtex]

Hello,
I have sales table contain product name, quantity and date.
- first how to get total quantity of sales for each product among all period in calculating column ?
- second I am using Power BI and i need to present products sales by sales group and period (I will classify them to groups according to sales amount and period is in last 12 month or 24, I will using both as a slicers)
BR

 

[Matt Allington]

- first how to get total quantity of sales for each product among all period in calculating column ?

You shouldn't do that. Please read my post about that here Calculated Columns vs Measures in DAX - Excelerator BI

Instead write a measure (not a calc column) like this.

=CALCULATE(SUM(Sales[Quantity]),ALL(Sales))

For the second, it would help if you posted a sample workbook. It sounds like a banding solution may work for you. Read about that here
Banding in DAX - Excelerator BI

 

[ahmedismailfourtex]

Thank you Matt for advice,
my data seems like

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Product Name[/TD]
[TD]Quantity[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]X[/TD]
[TD]10[/TD]
[TD]1/1/2016[/TD]
[/TR]
[TR]
[TD]Y[/TD]
[TD]20[/TD]
[TD]10/1/2015[/TD]
[/TR]
[TR]
[TD]z[/TD]
[TD]10[/TD]
[TD]20/1/2016[/TD]
[/TR]
[TR]
[TD]x[/TD]
[TD]15[/TD]
[TD]25/1/2015[/TD]
[/TR]
</tbody>[/TABLE]

I need to plot pie chart with sales quantity groups (>15,>10,<10), then I need to create a slicer with the period (2016,2015) and interact with booth (pie chart and slicer) in the same time.
thank you again and best regards.

 

[Matt Allington]

Yu need to create a calculated column. Read about that here. Banding in DAX - Excelerator BI