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
Richard76
Helper II
Helper II

Changing totals on tables

Guys is there any easy way to make the column totals a sum rather than an average in the table below :

 

Table.PNG

1 ACCEPTED SOLUTION

New Mesuare = SUMX( VALUES(family id[family id]), [price per item]))

 

excuse me forget to close the parentheses

View solution in original post

11 REPLIES 11
GaloSantamaria
Regular Visitor

Hello,

Try this:

New Mesuare = SUMX( VALUES(family id[family id]), [price per item]

greetings

Galo

New Mesuare = SUMX( VALUES(family id[family id]), [price per item]))

 

excuse me forget to close the parentheses

Thank you very much for your help that has solved it 

GaloSantamaria
Regular Visitor

Helo,

Try this:

create a new measure  = SUMX(VALUES(family id[family id]), [price per item]

vmakhija
Post Prodigy
Post Prodigy

@Richard76

I tried with my dataset. Here is how it looks with all SUM -

 

 

ALLSUM.JPG

 

 

 

 

 

 

 

 

 

 

 

I created a measure as follows -

SalesMeasure = IF(HASONEFILTER(Orders[Category]),AVERAGE(Orders[Sales]),
CALCULATE(SUM(Orders[Sales]),ALLEXCEPT(Orders,Orders[Region])))

 

And used this measure in below matrix table -

SUMANDAVERAGAE.JPG

 

 

 

 

 

 

 

 

 

 

 

Does this look similar to what you want?

 

Regards

Capture.PNG

 

I think the formulae you showed me is close but still can't get it to work. So the values in the above are averages but I want the total line for Jan17 to be £23.76 (£11.09+£12.67), Feb to be £24.2 and so on so I can plot the totals on a chart

@Richard76

 

Can you post the measure you are using?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

Hi @Richard76,

 

Shouldn't this do the trick?

 

total.PNG

Sorry didnt explain very well. The figure in the table is a new measure (price per item = sales value / qty) so I'm happy with that. But I just want the total along the bottom to be sum rather than an overall average if that makes sense...

@Richard76

 

Try this. Create a new measure to calculate the sum of values you want to display. Then use the following measure in your table:

 

measure = IF(HASONEFILTER(family id [family id]), [price per item], [sum measure])

 

(you obviously need to use the  column and measure references appropriate to your model).

 

See if that works,

regards, 

Paul. 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Hi thanks for this but still no joy . 

I'm trying to get my head around DAX so what exactly is this calc doing ??

 

 

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.