Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

column with IF order, total incorrect

Hello I have reviewed the posts on similar topics, but no solution suits what I need. I would appreciate assistance with this formula. I have a column (measure) and at row level the result is correct...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Syndicate_Admin ,

 

Your issue should be caused by IF() function. Here I suggest you to use SUMX() to get sum result based on

[Units prov Recibidas 2] measure.

New Units prov Recibidas 2 =
SUMX ( VALUES ( 'TableName'[Reference Comm] ), [Units prov Recibidas 2] )

 

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.