Forum Discussion
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 Power BI:
=IF(Y2="Y",(AL2*0.25),0)
Where:
Y2 = would be the column in Power BI with the criteria I want to meet
AL2 = the second column I want to multiply the value by the Gift Aid rate
0.25 = 25% of Gift Aid rate (static number, not a column)
Basically, I need to meet a condition in a column so I can multiply the second one based on a static rate number.
Is it because the number I need to multiply by is not a column instead?
Thanks,
Ana
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 .
19 Replies
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 CMeasure = IF('Table'[Y2]= "Y",CALCULATE(SUM('Table'[AL2])*0.25),0)Try this
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.
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.
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 .
Hi LukeFPowerBI , please check my response to my own post here - I found a solution on that link I shared in my response. There is also the calculation I used.
From what I rmember, that worked fine.
Thanks,
Ana
Hi I also tried this
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.
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.
I am new t
