Forum Discussion
Solved
Calculation Error
Hi, I have a calculation that isn't working as expected when using two different data points. Looking at the example below i want to be able to if i filter on just 'data 1' get the result 5. T...
Not sure I follow correctly how the model is built, but for the tables is see in the images, this should work.
SUMX( SUMMARIZE( 'YourTable', 'YourTable'[Identifier], 'YourTable'[Multiplier], 'YourTable'[Number] ), 'YourTable'[Number] * 'YourTable'[Multiplier] )
