Forum Discussion
Show items with no data: show items from one table based on data (no data) from other table
First, bravo for posting a clear explanation of the problem and sample data that is not a screen shot and thus has to be manually entered in order to replicate the problem. Nice job.
What you want is this Measure in your Names table:
MyMeasure = IF(SUM(HoursSpent[Hours spent])>0,SUM(HoursSpent[Hours spent]),0)
First, bravo for posting a clear explanation of the problem and sample data that is not a screen shot and thus has to be manually entered in order to replicate the problem. Nice job.
What you want is this Measure in your Names table:
MyMeasure = IF(SUM(HoursSpent[Hours spent])>0,SUM(HoursSpent[Hours spent]),0)
Thank you Greg_Deckler,
It solved the part of my problem now instead of getting blank I am getting 0 but I am still not getting the name of those employee who has not put any hours in Table 2.
I don't understand, if I create a table visualization with [Name] and [My Measure], I see all the names including the ones that have 0. Are you seeing something different or are you using a different visualization?
Sorry Greg_Deckler, I was having one more condition enabled bacause of that I was getting different values. I changed it.
Now all good, It worked and solved the problem. Thank you for the quick responce.
