Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ??
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |