Forum Discussion

tonvhemert3's avatar
tonvhemert3
Regular Visitor
3 years ago
Solved

Using MIN/MAX function in measure, but the total doesn't add up as expected.

Hi,   I am currently facing an issue where my values don't add up as expected. I have a table with different ratio's per country, called Verhoudingsgetallen. Let's say:   Country SolarVerhoud...
  • johnt75's avatar
    johnt75
    3 years ago

    Try

     

    DemandSolars =
SUMX (
    VALUES ( 'Table'[Country] ),
    VAR SolarVerhouding_ =
        CALCULATE(MAX ( Verhoudingsgetallen[SolarVerhouding] ))
    VAR SensorForecast_ =
        CALCULATE(SUM ( 'Salesforce budgetForecasts'[Forecast__c] ))
    RETURN
        SolarVerhouding_ * SensorForecast_
)

     

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Try

 

DemandSolars =
SUMX (
    VALUES ( 'Table'[Country] ),
    VAR SolarVerhouding_ =
        CALCULATE(MAX ( Verhoudingsgetallen[SolarVerhouding] ))
    VAR SensorForecast_ =
        CALCULATE(SUM ( 'Salesforce budgetForecasts'[Forecast__c] ))
    RETURN
        SolarVerhouding_ * SensorForecast_
)

 

  • tonvhemert3's avatar
    tonvhemert3
    Regular Visitor
    3 years ago

    Hi John,

     

    Thanks for your quick reply. I've tried this, but now I get a really big number as my total. So I don't think this is the solution.

     

     

    • johnt75's avatar
      johnt75
      Icon for Super User rankSuper User
      3 years ago

      I've updated my original post to force context transition, should be OK now I think

      • tonvhemert3's avatar
        tonvhemert3
        Regular Visitor
        3 years ago

        Thanks a lot. It works!