Substract products' string values from another measure in other table

[Talal141218]

Hello Profis, 

I have two fact tabels and there is no relation between them. 

The first table' is "Fact_Salesinvoiceline", which has a relation with Dimation table (Product). 

The second table is "Fact_Generalledger", which has no relation with Products' table. In this tabel i create a measure, which i want to substrict it from from profit of each Product. 

(Fact_GeneralLedger[Amazon-Rücksendungskosten]+ Fact_GeneralLedger[Werbkostenamazon]+Fact_GeneralLedger[Anteil Amazon von Logistiksaufwand WLL]). For an example the Werbkostenamazon measure is = 

Werbkostenamazon = CALCULATE(Fact_GeneralLedger[CM_Fact_GeneralLedger_Amount_CCY], FILTER(Dim_LedgerAccount, Dim_LedgerAccount[LedgerAccount] = "6600"), FILTER(Fact_GeneralLedger, CONTAINSSTRING(Fact_GeneralLedger[Fact_GeneralLedgerTransaction_Description], "amazon")))

With my measure work just the total and did't work for each product. The measure is :

Amazon D.Kosten Je STK =

var Amazonkosten = [Amazon D.Kosten "RÜ+M+WLL"]

var Absatzamazon = CALCULATE(Fact_SalesInvoiceLine[CM_SalesInvoiceLine_Invoice_Quantity], FILTER(Dim_Customer, Dim_Customer[CustomerName] = "Amazon EU SARL"))

RETURN DIVIDE(Amazonkosten,Absatzamazon). 

For more information please be free to ask. 

Thanks in Advance

[Anonymous]

Hi @Talal141218 ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. 

Also, please show your expected results using screenshots or virtual tables etc. We can better understand the problem and help you.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Talal141218]

Hi Carla,

Thanks for reponse. Unforetunately i am not able to share any data, becuause i don't have access to data transformation and for another resones. To simple my quation i want to unit the sum of column "Amazon D.Kosten je STK" for each row. 

Thanks in advance.