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 .

pratyashasamal's avatar
pratyashasamal
Memorable Member
3 years ago

Hi Anonymous ,
Try this calculation ,

 

Measure = IF(SUM('Table'[Y2])= "Y",CALCULATE(SUM('Table'[AL2])*0.25)),0)

if you want to have 0.25 or 25 % in column you can do that just you need to aggregate and then multiple .
For example :-
Where gift = 25 %
Measure = IF(SUM('Table'[Y2])= "Y",CALCULATE(SUM('Table'[AL2])*(SUM('Table'[Gift])/100)),0)

 

Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thansk for that. Just tried but it's saying it's incorrect:

    Thanks,

    Ana

    • pratyashasamal's avatar
      pratyashasamal
      Memorable Member
      3 years ago
      Measure = IF('Table'[Y2]= "Y",CALCULATE(SUM('Table'[AL2])*0.25),0)

      Try this

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Didn't work again:

        I'll probably create an extra column for the 25%.

  • 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.