Forum Discussion

Oblomov's avatar
Oblomov
Frequent Visitor
8 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Yes, you can use the nested usage of IF. 

 

Example: IF( Condition1, True,IF(Condition2,True).

 

You can use SWITCH function as well.

 

Thanks
Raj

Oblomov's avatar
Oblomov
Frequent Visitor
8 years ago

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).

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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