Forum Discussion

hgnisnattart's avatar
hgnisnattart
Frequent Visitor
5 years ago
Solved

Dynamic Scenario Calculation Based on Dropdowns

Hi, I'm trying to create a measure that uses the appropriate rate based on the currency scenario selected. I have the following screenshot example with 2 different entities: Currency and Plan/Actuals...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    hgnisnattart , try a new measure


    sumx(Summarize(PlanActual, PlanActual[Sceniro], PlanActual[Currency], PlanActual[Period] , "_1" , calculate(max(Currency[Rate]),filter(Currency, Currency[Currency]=max(PlanActual[Currency]) && PlanActual[Period] = Currency[Period])) *sum(PlanActual[local Amount])),[_1])

amitchandak's avatar
amitchandak
Super User
5 years ago

hgnisnattart , try a new measure


sumx(Summarize(PlanActual, PlanActual[Sceniro], PlanActual[Currency], PlanActual[Period] , "_1" , calculate(max(Currency[Rate]),filter(Currency, Currency[Currency]=max(PlanActual[Currency]) && PlanActual[Period] = Currency[Period])) *sum(PlanActual[local Amount])),[_1])

hgnisnattart's avatar
hgnisnattart
Frequent Visitor
5 years ago

amitchandak , thanks so much! This is working great :). I'm definitely going to have to spend some time breaking down the calculation to understand what's going on, but it works perfectly. Thanks again!