Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Probably a simple answer...

Hi Power-Bi Community, I have a question that probably has a really simple answer... but I appreciate anyones help with this! So, if I have a colmun of activities and another coumn of values (which...
General Comment
Need Help
Tips and Tricks
  • aj1973's avatar
    aj1973
    3 years ago

    The BLANK() function is considered as 0 as well.

     

    you can write this way also

    TrueOrFalse = IF(TABLE[Value] > 0 , "True" , "False")

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

I created a simplified pbix file(see the attachment), please find the details in it. You can create a measure as below to get it:

Measure = IF ( SUM ( 'Table'[value] ) + 0 = 0, "False", "True" )

Best Regards