Forum Discussion

Phil182's avatar
Phil182
New Member
3 years ago

Filter items with no data

Hi,

 

I have 2 reports combined. Report 1 will have eveything and report 2 just has somethings.  So I combine the 2 and I am trying to see what is on report 1 but not report 2. See below, I want to filter on the items with no data in movement type, but it only gives the option for items with a value. How can I filter on the no data? I have tried filtering on blanks and it doesnt work. Since the data isnt on report 2 I cant add any values anywhere. 

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Phil182 ,

     

    Try right-clicking on the field and clicking show items with no data.

    If I have misunderstood your question, please feel free to let me know.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

  • Phil182's avatar
    Phil182
    New Member
    3 years ago

    Yes, I can see the items with no Data, but I can't filter on them. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Phil182 ,

      If you are trying to filter out records where [MOVEMENT_TYPE] is blank. Please try new a measure like:

      Measure = IF(MAX('Table'[MOVEMENT_TYPE])=BLANK(),1)

      And  apply it to the filter:

      Best Regards,
      Gao
      Community Support Team

       

      If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

      How to get your questions answered quickly -- How to provide sample data