Forum Discussion
Through measure the multiple values are wrong
Hello asdf1608,
This is also easily done in Power BI! 🙂
Try this for your measure 2 instead:
Measure 2 = SUMX ( Sheet1, [Conversion] * Sheet1[Row ID] )The reason your original Measure 2 wasn't working is because you wanted the calculation to go row by row, but Power BI doesn't know that unless you use an iterator function (like SUMX); instead of going row by row, multiplying the row ID and conversion together then adding it all up at the end, it was adding up all the row IDs, adding up all the discounts, then multiplying the two numbers together (ie: 1,583.99 * 51963915).
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
Hello asdf1608,
This is also easily done in Power BI! 🙂
Try this for your measure 2 instead:
Measure 2 =
SUMX (
Sheet1,
[Conversion] * Sheet1[Row ID]
)
The reason your original Measure 2 wasn't working is because you wanted the calculation to go row by row, but Power BI doesn't know that unless you use an iterator function (like SUMX); instead of going row by row, multiplying the row ID and conversion together then adding it all up at the end, it was adding up all the row IDs, adding up all the discounts, then multiplying the two numbers together (ie: 1,583.99 * 51963915).
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
