Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
How would you amend the following Measure to sum with Distinct count
Solved! Go to 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
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
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |