Forum Discussion
setis
Post Partisan
Post PartisanSimple FILTER calculation
Dear experts, I have Table1: Entry Doc Type DocNr 155511 2 1574028 155511 2 1574028 155511 2 1574028 155511 2 1574028 155511 3 15191 155511 3 15191 T...
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...
littlemojopuppy
Community Champion
Community ChampionDo the results I posted a screen snip of seem reasonable based on the sample data you provided?
littlemojopuppyCommunity Champion
Community ChampionResults based on the PBIX you provided...