Forum Discussion
Simple FILTER calculation
Your data model should have Table 1 with joins to Table Sales (Table1.DocNr -->Table Sales.Sales DocNr) and Table Credit (Table1.Doc Nr --> Table Credit.DocNr) independent of each other.
From there, it should be fairly easy to create the measures:
- Sales = SUM(Table Sales.Amount)
- Credit = SUM(Table Credit.Amount)
Hope this helps!
Results based on the PBIX you provided...
Dear amitchandak and itsmebvk thanks a lot for trying to help. Unfortunately, the solution didn't work for me.
I think that I didn't explain myself good enough, so I have just created a dummy file illustrating the issue. Please see it here: https://drive.google.com/file/d/1bQyBNs-7uu8e4sOiVRZnEkz57fKQXFMl/view?usp=sharing
The measures that I need is one for sales and one for Credit. The one for sales will find in Det_CLE the Doc Nr with the Doc Type "Sales" and use the Doc nr in the table sales to get the sum of the amount with that Doc No.
Same procedure with Credit.
I hope that it is more clear now. If anyone could take a look at this and give me a hand, I would really appreciate it.
Thanks!
Your data model should have Table 1 with joins to Table Sales (Table1.DocNr -->Table Sales.Sales DocNr) and Table Credit (Table1.Doc Nr --> Table Credit.DocNr) independent of each other.
From there, it should be fairly easy to create the measures:
- Sales = SUM(Table Sales.Amount)
- Credit = SUM(Table Credit.Amount)
Hope this helps!
littlemojopuppy Thanks for this.
These would be many-to-many relationships. Wouldn't there be any issues with that for this purpose?
Do the results I posted a screen snip of seem reasonable based on the sample data you provided?
Results based on the PBIX you provided...