Sum if condition with Month year

[richard24best]

Hi All,

I am trying to get the sum with the below condition

sum({$<[CTMP Match Status]={'Matched'}>}[CTMP Number of Allocations])

wanted to include one more [CTM Mth Year] in the above to get the sum for the month and year while creating a bar graph.

Could you please suggest me how can i use it above.

Thanks,

Richard

[OmarBenSalem]

Just add your [CTM Mth Year]  as Dimension and leave the measure as it is..

[sunny_talwar]

You want the sum for max MonthYear?

[richard24best]

Hi Sunny / Omgar,

Apologies as i was not clear on my query.

Well i am trying use a combo chart so for line chart percentage measure its working fine.

But regarding Bar graph i want it use different Month year dimension is it possible to accomodate in measure expression?

FYI i am using different mthyr as dimension for line graph and i want to use MonthYear during bar graph measure

Regards.

Richard