Forum Discussion
Bryanna
Helper II
3 years agoRoundup not summing correctly
Hi,
I am using the following measure to round up, however it is not summing correctly its just rounding the total. I found where someone wrote to use the following measure below, however this is on a column not a measure and my below measure will not populate where they have 'Crate EQ'. Any ideas?
ROUNDUP('Shipped Cases'[P/TL],0)
Round_new =
VAR _new =
SUMMARIZE ( 'Table', 'Table'[Crate EQ], "_value", [_your roundup] )
RETURN
IF (
HASONEVALUE ( 'Table'[Crate EQ] ),
[_your roundup],
SUMX ( _new, [_value] )
)