Showing Items With No Data vs Items with Data

[Anonymous]

Hi

Hope all is well and everyone is safe 

I need some assistance most likely a very basic issue, however kind of stuck. I am currently trying to show a comparison between items with data for a specific week and the items with no data for the week. I know PowerBI has this great feature (Show Items with No Data) that includes the items with no data aswell as the items that have data for that week. Is there a way to only show the items with no data for that week? Apologies if this was a broad question , kind of new to this . Any help will be much appreciated

Cheers!!

[amitchandak · Accepted solution]

@Anonymous , Create a measure with +0 and check

Sum(Table[Value]) +0

[Anonymous]

Thanks for that !!