Forum Discussion
Multiply two values from the same table
Hi all I have a table with transactions in it as well as well as rate per transaction. I would like to write a dax formula that finds the rate for the month and for the customer, and multiple it ...
Result measure : =
CALCULATE ( SUM ( Data[Value] ), MeasureTable[Measure] = "transactions" )
* CALCULATE ( SUM ( Data[Value] ), MeasureTable[Measure] = "rate" )
I tried that and I got some really big numbers. I gave you a small sample of a larger table. Would it be different if there were multiple GP Vendor IDs in a month? Here is an example:
GP Vendor ID Store Measure Value Month ACME01 1 transactions 100 1/1/2021 ACME01 1 rate 10 1/1/2021 ACME01 2 transactions 110 1/1/2021 ACME01 2 rate 20 1/1/2021 ACME01 3 transactions 115 1/1/2021 ACME01 3 rate 30 1/1/2021
