Sum of Measured Column

[Jodes007]

Hello 

I have the following measure in my matrix:

Measure 1 = 

Count of Email Address x Sum of Cost Per User =

DISTINCTCOUNT('App Usage_Detail'[Email Address]) * SUM('Estimated Costs per Email_P08'[Cost Per User])

Matrix has following data, each column is from a different source data. 

IT Service	Costs per User	Count of Email Address	Measure 1 Results
Service 1	939	761	741,198
Service 2	1,229	185	227,272

The measure is working as expected but I want to show a sum of all the measures, in this case 968,470, instead it is showing 1,666,423??. Sum could be either in the table or in seperate visual.

Thanks for your help

Jodi 

[Jodes007]

Genious!!! Yes it worked thank you so much. 

[parry2k · Accepted solution]

@Jodes007 try this measure

Count of Email Address x Sum of Cost Per User =
SUMX ( VALUES ( YourTable[IT Service Column] ),

CALCULATE ( DISTINCTCOUNT('App Usage_Detail'[Email Address]) ) * 
CALCULATE ( SUM('Estimated Costs per Email_P08'[Cost Per User]) )
)

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡