Forum Discussion
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...
Yes, I can see the items with no Data, but I can't filter on them.
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