Forum Discussion

reshefy's avatar
reshefy
New Member
2 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    2 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.