Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
GA1993
Helper II
Helper II

Display total of sum per year

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..

 

GA1993_2-1634673635882.png

 

I have been experimenting with formulas but no luck 😞

 

1 ACCEPTED SOLUTION
smpa01
Super User
Super User

@GA1993  try this

 

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

 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

View solution in original post

8 REPLIES 8
smpa01
Super User
Super User

@GA1993  try this

 

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

 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Hi,

 

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

 

GA1993_0-1634676154908.png

 

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

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

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 😕

 

GA1993_0-1634677358468.png

 

@GA1993  what does the error say?

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

It says it cannot find the name Year

 

GA1993_0-1634678962430.png

But this is my Date table 

GA1993_1-1634678975577.png

 

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

 

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

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors