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)

     

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)