Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 | |
101 | |
84 | |
79 | |
69 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |