Display total of sum per year

[GA1993]

Hi, I would like to display the values as SUM of TOTAL PER YEAR as listed on the EXPECTED column below..

How do I do this correctly because on my graph that I have been developing it is displaying as the Total Allotted instead of the EXPECTED..

I have been experimenting with formulas but no luck 😞

[smpa01 · Accepted solution]

@GA1993  try this

Measure:= calculate(sum(tbl[TotalAllotted]),allexcept(tbl,tbl[year]))

[GA1993]

Hi,

It doesnt seem to accept the suggested solution. I think the FACT DAX doesnt work 😞

[smpa01]

@GA1993  Fact is the name of the table. Edited, try again.

[GA1993]

Is there a reason why the Year is not acccepted? I have made the relationship between the MP Engine and Date so Im not sure where the issue is 😕

[smpa01]

@GA1993  what does the error say?

[GA1993]

It says it cannot find the name Year

But this is my Date table 

[mervemalli]

try:
'Date'[Date].[Year]

[smpa01]

@GA1993  use a Date table, and not date hierarchy. You can find plenty of examples in this forum & / web about DAX Date table.