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?