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 12...
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.
