Forum Discussion
Solved
Show items with no data: show items from one table based on data (no data) from other table
Hi, Please consider following senario: Table 1 Name ID A 1 B 2 C 3 D 4 E 5 F 6 G 7 H 8 Table 2 Date ID Hours spent 26-09-2016 ...
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)
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.