Calculating the sum of a measure

[Anonymous]

Hi 

Hope all is well

I am tryting to calcuate a sum of a measure . Is there way that you can treat a mesure like a column and reference it within your sum function for example 

Measure 2 = Sum('Logs Usage'[username]) + 0,  instead of calling username column I would like to reference a existing measure I calculated called countusername . 

Any Help will be greatly appreciated

Cheers!!

[amitchandak]

@Anonymous ,

Not very clear. Try

sumx(Table,[measure])

[Anonymous]

Thanks for the @amitchandak  sorry for being not to clear I am quite new to this. I tired the above   So I want to be able to show zero values aswell . The reason behind this I have a username with n coulmn which I have created a measure that calcuates the distinct users in a company that were active within a timeframe and groups it by compnay name. The issue I had was if I was to directly create a sum function based on the username column it will give this error :

That would have been the easiest way , my ideal goal is show compaies with zero active users aswell as the active users. As shown below that is what I want but also in the matrix table to show zero if users were not active within a timeframe. Really sorry if that made no sense . 

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Try:

SUMX( VALUES( 'Logs Usage'[username] )  ,[countusername]))

If the problem persists,could you share the sample pbix via cloud service like onedrive for business?

Please mask any sensitive data before uploading

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

[Anonymous]

@V-lianl-msft Thanks for that that worked , only issue I have now is getting the zero values to appear . Is there a way I can get this logic to work like the same as this logic 

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])). 

Thanks for the help thus far !!

[V-lianl-msft]

Hi @Anonymous ,

Sorry for the late reply

Try

var test =  SUMX( VALUES( 'Logs Usage'[username] )  ,[countusername]))
return if(isblank(test),0,test)

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