Average Sales when Multiple months are selected in the Slicer

[Anonymous]

I have an issue to calcaluate average of sales, cost, and commodity% when multiple months are selected from Slicer.

I have a table visual and month slicer as seen below

The month Slicer is defaulted to select only one month and displaces the table visual above. The measure used was sum of Sales, cost, and Commodity% which works fine for only one month selected in the slicer. However, whenever I select multiple months, i was to calculate the average of Sales, Cost% and Commdity%, hence it should look like this

Sales, cost, and commodity calculate it average based on the months selected in the Slicer. But Commodity% remains the same.

How can i achieve this to calculate weighted average od sales, cost and Commodity% using dax.

[amitchandak · Accepted solution]

@Anonymous , if sales is a measure and you need month avg then try like

AverageX(Values(Date[Month Year]), [Sales] )

Assumed [Month Year] from date table