Do not apply the measure in the results

[Anonymous]

Hi everyone!

How can I sum data per month. Data is a measure.

Do not apply the measure in the results, summarize by month

Measure = [OOS, L] * SUM(GPDP[Gross profit direct production]) / SUM(GPDP[Total Volume])

[amitchandak · Accepted solution]

@Anonymous ,

Asumming month year is coming from date table

you measure should be

Measure = Sumx(Values(Table[Month Year]), calculate([OOS, L] * SUM(GPDP[Gross profit direct production]) / SUM(GPDP[Total Volume])))