Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
4 years ago
Solved

IF STATMENET

Hello all, how would i display a messaage if total volue = 0 or blank.

Need Help
  • yakamoz007's avatar
    yakamoz007
    4 years ago
    NewbieJono wrote:

    Hello all, how would i display a messaage if total volue = 0 or blank.

     

    Hi I hope I understand your question.

    you can try with such formula

     

     

    Total value =
if(or('table'[total value] = 0, ISBLANK('table'[total value])
, ResultIfTrue , ResultIfFalse)

     

1 Reply

  • yakamoz007's avatar
    yakamoz007
    Helper I
    4 years ago
    NewbieJono wrote:

    Hello all, how would i display a messaage if total volue = 0 or blank.

     

    Hi I hope I understand your question.

    you can try with such formula

     

     

    Total value =
if(or('table'[total value] = 0, ISBLANK('table'[total value])
, ResultIfTrue , ResultIfFalse)