Forum Discussion
ricsolbra
4 years agoFrequent Visitor
Sum Distinct not working in a matrix
Hi guys, I'm really stuck in a SUM DISTINCT problem. In the dataset I have various ID, which are 'businesses created', and these businessess have installments, in many cases more than 1 insta...
v-chenwuz-msft
Community Support
4 years agoHi ricsolbra ,
Can you explain how the 657.828 is calculated? What the output you want for the example data you provided in picture 1?
Or you could share the pbix file without sensitive data and expect result if possible.
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Best Regards
Community Support Team _ chenwu zhu
ricsolbra
4 years agoFrequent Visitor
I created in a .pbix file what I've been trying to do. Hope it helps:
https://drive.google.com/drive/folders/1I0fEwjtScFxYTH8ygCgudr1uyh7VsvZK?usp=sharing
Tks in advance.