Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Guys is there any easy way to make the column totals a sum rather than an average in the table below :
Solved! Go to Solution.
New Mesuare = SUMX( VALUES(family id[family id]), [price per item]))
excuse me forget to close the parentheses
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
Helo,
Try this:
create a new measure = SUMX(VALUES(family id[family id]), [price per item]
I tried with my dataset. Here is how it looks with all SUM -
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 -
Does this look similar to what you want?
Regards
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
Can you post the measure you are using?
Proud to be a Super User!
Paul on Linkedin.
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...
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.
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 ??
User | Count |
---|---|
128 | |
108 | |
99 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |