Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Showing Items With No Data vs Items with Data

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!!

 

  • Anonymous , Create a measure with +0 and check

     

    Sum(Table[Value]) +0

2 Replies

  • Anonymous , Create a measure with +0 and check

     

    Sum(Table[Value]) +0

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks for that !!