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

Hi there!

Have you tried only this:

Revenue - Total Including Predicted (USD) =
SUMX(
    'Revenues',
    'GST Revenues'[Predicted Revenue Calculator (USD)] * Data[Volume - Lots]
)
  • CM_Mills's avatar
    CM_Mills
    Helper II
    3 years ago

    Hi, Thanks for reviewing. Without the sumx before the volume i get the following:

     

    A single value for column 'volume - lots' in table 'data' cannot be determined. This canhappen when a measure refers to a column that contains many values without specifying an aggregation such as min,m ax,count or sum to get a single result.

    • 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?