Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

IF Statement plus Multiplication using static number

Hi all!   Sorry if it's a silly one (because I feel like it should be a pretty straight forward one), but can I have help with the below please.   I'm trying to replicate the formulae below in Po...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    I found the answer here -> https://www.enjoysharepoint.com/power-bi-measure-multiply/ (Power BI Measure multiply by 100).

     

    _GA Income Calcs = IF(SELECTEDVALUE('Single Donations'[GiftAid]) = "Yes", CALCULATE(SELECTEDVALUE('Single Donations'[amount]) * 0.25, FILTER('Single Donations', 'Single Donations'[GiftAid] = "Yes")), 0)
     

     

    Thank you so much for all your help with this, pratyashasamal .

LukeFPowerBI's avatar
LukeFPowerBI
New Member
2 years ago

Can you help I have copied your answer but getting errors

I am trying to use the basic element of this and struggling its not accepting the argument for me

GA Income Calcs = IF(SELECTEDVALUE('vw_Transactions'[GiftAidStatus]) = "TRUE", CALCULATE(SELECTEDVALUE('vw_Transactions'[DiscountedValue]) * 0.25, FILTER('vw_Transactions','vw_Transactions'[GiftAidStatus]) = "TRUE")),0)


i get this
The syntax for ',' is incorrect. (DAX(IF(SELECTEDVALUE('vw_Transactions'[GiftAidStatus]) = "TRUE", CALCULATE(SELECTEDVALUE(vw_Transactions[DiscountedValue]) * 0.25, FILTER(vw_Transactions,vw_Transactions[GiftAidStatus]) = "TRUE")),0))).

 

I honestly cant see what i am doing wrong because based on the info on this post and aligning to my own data this should work?  I am new to powerbi only been a user for a few weeks.

LukeFPowerBI's avatar
LukeFPowerBI
New Member
2 years ago

I also tried the second tip 

Gift Aid Income = IF('vw_Transactions'[IsGiftAided]= "TRUE",CALCULATE(SUM('vw_Transactions'[DiscountedValue])*0.25),0)
For some reason the first past the IF('vw_Transactions'[IsGiftAided]= "TRUE" seems to only want to pick up measures that are created and not table data.