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...
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...