topic Substract products' string values from another measure in other table in DAX Commands and Tips

Substract products' string values from another measure in other table

Talal141218 — Tue, 02 Jul 2024 14:31:31 GMT

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

Re: Substract products' string values from another measure in other table

Anonymous — Wed, 03 Jul 2024 06:06:56 GMT

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.

Re: Substract products' string values from another measure in other table

Talal141218 — Wed, 03 Jul 2024 08:03:43 GMT

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.