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.
Hi, I have a situation where a SUMX formula is behaving correctly in Desktop but provides very big numbers in the service. Never seen it before.. a bug?
This is the formula:
Cost per Invoice Line =
sumx(Fakturalinjer ; Fakturalinjer[Quantity]*Fakturalinjer[Unit_Cost_LCY])
see here: (No. 1019354 and the totals)
Desktop
Service (No. 1019354 and the totals)
You may check if the following post helps.
https://community.powerbi.com/t5/Service/Thousand-Separator-and-Decimal-Separator/m-p/633330#M63484
Hi @Larstc75 ,
Are tou sure that on both setups you have the same filters?
On the images you show the last rows are dfifferent so the calculations are not comparable, this can also the way the screenshots were taken but to what I can see the service image as more lines in the calculation than the desktop.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsYes I am sure. If you pay close attention, you will notice that there is a factor 100 difference on the Omk column for No. 1019354 and the Totals are just to the moon. This could not be done accidently by a filter.
I think it is a bug. just don't know how to fix it.
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 | |
102 | |
88 | |
63 |