topic Re: Display total of sum per year in DAX Commands and Tips

Display total of sum per year

GA1993 — Tue, 19 Oct 2021 20:02:55 GMT

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 — Tue, 19 Oct 2021 20:51:40 GMT

GA1993 try this

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

GA1993 — Tue, 19 Oct 2021 20:42:58 GMT

Hi,

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

smpa01 — Tue, 19 Oct 2021 20:52:14 GMT

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

GA1993 — Tue, 19 Oct 2021 21:03:07 GMT

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 — Tue, 19 Oct 2021 21:07:32 GMT

GA1993 what does the error say?

GA1993 — Tue, 19 Oct 2021 21:29:43 GMT

It says it cannot find the name Year

But this is my Date table

smpa01 — Tue, 19 Oct 2021 21:32:55 GMT

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

mervemalli — Tue, 21 Feb 2023 08:14:09 GMT

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