Inaccurate results displaying at Total

[Anonymous]

Hello Community,

I need the negative sign (-) in Pieces Out and Order shipped values to be removed. The total value displaying is not accurate as well.

See my measures formula:

Pieces Out = IF ( MIN ( 'Table Name'[Column] ) < 0, MIN ( 'Table Name'[Column]  ), BLANK () )

Orders Shipped = CALCULATE(SUM('Table Name'[Column] ),'Table Name'[Column]  IN {"CO"})

Cheers.

@amitchandak 

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please have a try.

Create a measure.

measure=
var _b = SUMMARIZE('table','table'[month],"aaa",'table'[Pieces Out])
return
IF(HASONEVALUE('table'[month]),'table'[Pieces Out],SUMX(_b,[aaa]))

measure_ordershipped=
var _b = SUMMARIZE('table','table'[month],"aaa",'table'[Orders Shipped])
return
IF(HASONEVALUE('table'[month]),'table'[Orders Shipped],SUMX(_b,[aaa]))

I have also found a helpful post, please refer to it to see if it helps you.

Dealing with Measure Totals 

If it does not help, please provide your pbix file without privacy information and more details with your desired output.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you

[amitchandak]

@Anonymous ,

Try like

sumx(Values(Date[Month]), Pieces Out = IF ( MIN ( 'Table Name'[Column] ) < 0, MIN ( 'Table Name'[Column] ), BLANK () ) )

Refer to video from Curbal- If needed

https://www.youtube.com/watch?v=ufHOOLdi_jk