total incorrect

[mark_mcadam2]

thought is was a simple sum there are no filters or dax expressions used. all road_total values for all region_id powerbi gives me this result REGION_ID Road_Total B 33406.6 C 69691 D 0 G 0 M 12008.7 S 13410.7 T 29643.9 W 0 Total 167,913,307.00 same query on same data with SQL give me result below. REGION_ID (No column name) B 272875.40 C 2383902.80 D 0.00 G 0.00 M 101533.30 S 774614.60 T 518831.40 W 0.00 tried to do a supprt request but got

[leitat-services]

I have a similar issue. For a 20 rows table, countrows returns 400, and for a distinct count for 4 different values, the function returns 80, multiplied by 20 both cases.