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
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 ?

     

    • pratyashasamal's avatar
      pratyashasamal
      Memorable Member
      3 years ago

      Try this once,
      This will work only from the Y2 column (GiftAid) column datatype is text and it also has a value of Yes in it . Exact function will match the Y2 column with Yes text and return a True / false column .

       

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Sorry, also didn't work. After the "Exact", it doesn't allow me to chose a table.

         

        GiftAid column is Text

        Amount column is Decimal number.