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 .

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Again, it doesn't allow me to select a table, only the other measures I have.

 

Would any screen shot help? Not sure of what to be honest hehe I think the issue is the aggregation after the IF, isn't it?

pratyashasamal's avatar
pratyashasamal
Icon for Memorable Member rankMemorable Member
3 years ago

This is ss , 
Measure 3 is where is am checking if the condition is Yes or not .
Then multiplying it with my sales value .
and Measure 2 is a simple measure with "Yes" or "No" values.