Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Blank() Not Ignoring Zero

Hi Experts,

 

When I use Blank () its ignoring 0 and Blank rows , but I required it to remove only blank rows not the 0 . How to do it.  Below is my measure and attached is pbix file.

 

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi amitchandak Ji,

     

    I have made some changes to your solution measure. Its wokring fine. Thanks a lot for your help!

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , change  Sheet[revenue] <> blank() like 

     

    not(isblank(Sheet[revenue]))  && Sheet[revenue] <> 0

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi amitchandak Ji,

       

      I have made some changes to your solution measure. Its wokring fine. Thanks a lot for your help!