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 |