Forum Discussion
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...
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
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
Many Thanks for the feedback