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 Po...
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 .
Please check once what is the datatype of GiftAid column and change it to text if it not a text .
It is a Text. And it's not a measure, it's a column.