Forum Discussion
Return specific value as default when IF statement is FALSE
Hello all, I have a dashboard featuring both a Table visualization of investments, and a corresponding Card visualization which displays the return for a specific investment when that particul...
Thank you for your reply rajendran, but I think maybe I wasn't clear in my question...I am having trouble in figuring out how to specify exactly which row to return.
I've tried a CALCULATE function where I specify the row (which we'll call TOTAL RETURN), but it is still pulling a blank (although the formula is still performing correctly when I select an individual investment).
Hi Oblomov
Ok, since no sample data / data model is given, am giving the sample code for your requirement.
Your_Field=
VAR inFilter= CALCULATE( MAX(Table1.column1), FILTER(Table1,Table1[column2]="Investment Type"))
Return
IF( HASONEVALUE('Investment Name'), VALUES('Investment Return') ,inFilter)
Hope this helps.
Thanks
Raj