Forum Discussion

CM_Mills's avatar
CM_Mills
Helper II
3 years ago
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...
  • PabloDeheza's avatar
    PabloDeheza
    3 years ago

    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]
)

     

PabloDeheza's avatar
PabloDeheza
Solution Sage
3 years ago

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]
)

 

CM_Mills's avatar
CM_Mills
Helper II
3 years ago

PabloDeheza Thank you for taking a look.

 

I have tried your solution but it isn't working. I think the issue is that 'Number' and 'Multiplier' are located in different tables. How would i take this into account?