Being able to view data with 0, in SUMX formula

[Anonymous]

I recently have had some luck using  this formula to show values with no data  - Sum('Updates Made'[Updates]) + 0 - this shows all updates made by companies aswell as instances when companies have made zero updates . Is there a way to add this logic to this formula, to show when companies had zero active users  - SUMX( VALUES( 'Logs Usage'[username] )  ,[countusername])). For some reason when it does not allow me to add the + 0 at then end of the SUMX formula . Any help will be much appreciated. Please let me know if you require more information

[amitchandak · Accepted solution]

@Anonymous ,  Formula is not clear. But you should able add +0 like

([zero active users] - SUMX( VALUES( 'Logs Usage'[username] ) ,[countusername]))+0

Or use the option Show item with No Data