Forum Discussion

akapelle's avatar
akapelle
Frequent Visitor
4 years ago
Solved

Measure based on dynamic selection not adding up to total

Help appreciated, the solutions found online did not help me so far. In our data model the exchange rate over the total period is determined based on the max selected period (month) and with this ex...
Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    akapelle,

     

    Try this measure:

     

    BalanceTotal in Currency Totals = SUMX ( VALUES ('Currency'[Month] ), [BalanceTotal in Currency] )

     

    Data model:

     

     

    Result:

     

     

DataInsights's avatar
DataInsights
Super User
4 years ago

akapelle,

 

Try this measure:

 

BalanceTotal in Currency Totals = SUMX ( VALUES ('Currency'[Month] ), [BalanceTotal in Currency] )

 

Data model:

 

 

Result:

 

 

akapelle's avatar
akapelle
Frequent Visitor
4 years ago

Thanks DataInsights 
Struggling to understand exactly what you did there but will dive deeper into that soon.