Sum with Distinctcount

[Anonymous]

Hi Experts

How would you amend the following Measure to sum with Distinct count

Accounts Where Notice Has Been Logged (£) = CALCULATE(

DISTINCTCOUNT('STG Fact_To_Do'[Payzone_Ref]),

FILTER('STG Fact_To_Do','STG Fact_To_Do'[Payzone_Ref] in VALUES('STG Fact_Agreement'[Bill_To_Merchant_ID]) && 'STG Fact_To_Do'[Task_Results] in {"DDM Set Up Paper","DDM Set Up Phone","DDM Updated - Paper","DDM Updated - Phone","DDM set-up phone","DDM updated-phone"}))

My Sum Measure is

Annulaised Value = 

SUM(STG_FACT_Revenue[Annualised_Revenue])

[vivran22 · Accepted solution]

Hello @Anonymous 

Are you looking for to sum the STG_FACT_Revenue[Annualised_Revenue] based on the output of the measure of Accounts Where Notice Has Been Logged (£) ?

How are STG_FACT_Revenue & STG Fact_To_Do tables are related?

Can you share a sample data with the expected output?

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

[Anonymous]

Many Thanks for the feedback