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

      • pratyashasamal's avatar
        pratyashasamal
        Memorable Member
        3 years ago

        No need what is data type of GiftAid column ?