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.
Hello,
I ended up identifying a strange result in a DAX.
Applying the context here in this brief text, it is a summary of total sales names, being divided by an accumulated daily share.
Below, one exemple.
In yellow, BRL 13,587.64/0.2727 = BRL 49,826.32. Is correct.In orange, BRL 383.29/0.2727 = BRL 8,976.35. By the logic of the calculation, it should return R$ 1,405.54...
The DAX involved in the calculation are:
current GMV=CALCULATE(SUMX(fPurchase, fPurchase[gmv]),dCalendar[actual_month] = "Yes")
accumulated goal =
CALCULATE(
[Meta],
FILTER(
ALLSELECTED(dCalendar),
dCalendario[Date] <= MAX(dCalendario[Date])
), dCalendario[actual_month] = "Yes") //Here I accumulate the daily share to complement other calculations.
Forecast = DIVIDE(GMV Atual, Meta acumulada, 0)
I ran several more tests using different templates and frameworks, but the result turned out to be the same.
Hi @madureirav ,
Please share a sample file with me and show me a screenshot with the result you want.
This will make us easier for me to find the solution.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |