Total of a measure with selectedvalue and parameter

[Anonymous]

Hi all,

can you help me out please. I created the attached measure and want to get a sum (total of it) how can I do that please.

The measure contains "Selectevalues" and "Parameter". I tried sumx but it doesn't give correct totals.

Thanks,
Miriam

[amitchandak · Accepted solution]

@Anonymous , You can create a measure like, of put this code into var and use that

SUMX(Values(Calendar[Month]), [IYR Projection])

Bascially, you need to use a grouping . You might have use Month or some other column in the visual

[Anonymous]

Thank you that worked. The mistake I did was not putting Values in the equation. So I wrote it initially like this:

SUMX((Calendar), [IYR Projection])