Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm struggling to get the value I want from DAX.
I have a column (un-summarised) with the number of Months remaining for each customer.
I have a measure to calculate the Average $ spend over the months they have already spent.
And I have attempted to calculate the average spend, multiplied by the number of months remaining.
The goal is to predict how much spend we will have as a total, based on each customers average spend, multiplied by their number of months remaining.
My rows are calculating, but the total of $850,889.62 is clearly not correct.
My total should be $69,604.09 (final column sum).
How can I achieve this? My data is is spend by grouped by customer and month.
=sumx(summrize(table,table[month],table[customer]),[months remaining]*[average $ per month])
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |