Forum Discussion

gianmarco's avatar
gianmarco
Icon for Helper IV rankHelper IV
5 years ago
Solved

Total Value does not change in a simulation environment

Dear Super-Duper Users, I need your help on this.   I have the following measure: IF(SELECTEDVALUE('Slicer Name'[Slicer Name])=MAX(Table1[Name]),([Sum])*(1+Parameter[Parameter Value]),([Sum])) ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, gianmarco 

    You need to  add a new measure "Total 2" as  below :

     

    Total = IF(SELECTEDVALUE('Slicer Name'[Slicer Name])=MAX(Table1[Name]),([Sum])*(1+Parameter[Parameter Value]),([Sum]))
    Total2 = SUMX(Table1,[Total])

     

     

    Please check my sample file for more details.

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

gianmarco's avatar
gianmarco
Icon for Helper IV rankHelper IV
5 years ago

Dear amitchandak , [Sum] is already a nested measure which uses SUMX.

Anyway, I try to use your solution but it doesn't work.

I don't know why the total won't change...

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, gianmarco 

You need to  add a new measure "Total 2" as  below :

 

Total = IF(SELECTEDVALUE('Slicer Name'[Slicer Name])=MAX(Table1[Name]),([Sum])*(1+Parameter[Parameter Value]),([Sum]))
Total2 = SUMX(Table1,[Total])

 

 

Please check my sample file for more details.

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.