Forum Discussion
reshefy
2 years agoNew Member
Create a table visual showing items with no data
Assume that I have a list of doors, and I assign a unique name to each door – I will call the list of doors my inventory. Each door has a sensor that registers the time someone passed through the...
- Anonymous2 years ago
Thanks for the reply from Greg_Deckler , please allow me to provide another insight:
Hi, reshefy
Regarding the issue you raised, my solution is as follows:
1.First I have created the following table and the column names and data are the data you have given:
2.Create calculated table references:
Table2 = VAR T2 = SELECTCOLUMNS ( 'Table', "Value", LEFT ( 'Table'[information], 5 ) ) VAR T3 = { "Door1", "Door2", "Door3", "Door4" } RETURN EXCEPT ( T3, T2 )3.Here's my final result, which I hope meets your requirements.
Please find the attached pbix relevant to the case.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
2 years agoCommunity Champion
reshefy You are going to need a, probably, disconnected table that lists all of your doors. I just solved a similar issue here: