I am having issues with calculating some data. I have two tables of data.
- Table 1 has a unit's selling price.
- Table 2 has the quantity of units sold based on a date
I've got a Measure with the following formula added into Table 2:
xExtAmt = SUM('Table 2'[Units]) * SUM('Table 1'[SellingPrice])
For the most part it works great, but I've been trying to use some Matrix (Pivot), Card, and Table visuals to calculate some totals and the calculations are WAY off. I'm guessing there is something wrong with what I'm doing here, but I'm not sure what. Between the tables, there is a unique ID field that connects the Unit w/Price and the unique date record of the sale.
I think I may be struggling with what is allowed or not allowed with Direct Query datasets. Any ideas/guidance would be much appreciated. Currently, I'm stuck with a dataset that should be telling me $7.8M, but instead I'm getting $46M. Way off.