Forum Discussion

DJsummers's avatar
DJsummers
Helper I
4 years ago
Solved

IF Function Assistance

Hi In the below table, I have a Standard weight and I have a parent age. If the parent age is below 35, then I want the standard weight to be reduced by 5% (multiplied by 0.95) I tired doing it...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi DJsummers 

     

    Use SUMX instead of SUM

    New Target = IF('CumulativeWeightsView2'[ParentAge]<35, SUMX('CumulativeWeightsView2', 'CumulativeWeightsView2'[StandardWeight]*0.95))

     

    Regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
4 years ago

Hi DJsummers 

 

Can you please share some data or your PBIX file so I can see what you're working with.

 

Regards

 

Phil

DJsummers's avatar
DJsummers
Helper I
4 years ago

Hi PhilipTreacy , I am linked to an sql server so not sure you would be able to see anything if I shared the pbix file? Also, I'm guessing that is related to what I am seeing...?