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 particular investment is selected in the table.

 

However, when NO investment is selected (ie, the user clicks somewhere outside the table), I would like the Card to default to the return for the TOTAL group of investments.  

 

I'm using the following formula:

IF( HASONEVALUE('Investment Name'), VALUES('Investment Return') )

 

As you can see, when the IF statement is false, it returns a blank; Is there some way I can change the false result to return a specific field for a specific row?

Need Help

3 Replies

  • 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