Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sum with Distinctcount

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

 

 

Need Help
  • vivran22's avatar
    vivran22
    5 years ago

    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

     

2 Replies

  • vivran22's avatar
    vivran22
    Community Champion
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      Many Thanks for the feedback