Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I want to calculate the SUM of the ratio for each month. What I would expect is value 138,26 in every row in column ‘Sum of Ratio’ when month = 1. And another value that corresponds to the sum of that month.
When I hardcode value 1 in the fitler it works (but that's not the solution ofcourse 😉
-> FILTER(dimCalculations, dimCalculations[Month] = 1)
My approach comes from excel, but I guess that doesn’t work here. Can anyone help me in the right direction?
Kind regards,
Steve
Solved! Go to Solution.
hi @SteveMBSDO
try like:
Sum of Ratio =
SUMX(
FILTER(
dimCalculations,
dimCalculations[Month] = EARLIER(dimCalculations[Month])
),
dimCalculations[Ratio]
)
or like:
Sum of Ratio =
CALCULATE(
SUM(dimCalculations[Ratio]),
ALLEXCEPT(dimCalculations, dimCalculations[Month])
)
hi @SteveMBSDO
try like:
Sum of Ratio =
SUMX(
FILTER(
dimCalculations,
dimCalculations[Month] = EARLIER(dimCalculations[Month])
),
dimCalculations[Ratio]
)
Great! Thank you FreemanZ. Both of your answers work ;-)!
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |