Forum Discussion
Calculate Expected Entries
By default Power BI only shows data it has, not the data that is missing. To work around that enable "Show items with no data" and/or create dimension tables that list all buildings with all floors, regardless if they had a health check or not. You can then use the columns from these dimension tables in you visuals as the main columns.
Is there a measure what I can use a target that would state whether I have either a completed, missing entry or too many entries based on that I expect a specific amount of entries for each building on any given date. For instance, Building A has 6 floors, which I expect 1 entry per floor (whether full or partially complete) to be made every single date, if this isn't the case, then either a compete, partial or too many entries is given based on whether the 6 has been met or not. Below is a sample of the data that could be recorded.
Date Buildings Floors Extinguisher is in good condition Exit routes visible and clear Alarm drill working
04/01/2020 A 1 Yes No Yes
04/01/2020 A 2 Yes Yes Yes
04/01/2020 A 3 Yes No
04/01/2020 A 4 No Yes Yes
04/01/2020 A 5 Yes Yes Yes
04/01/2020 A 6 Yes Yes Yes
04/01/2020 B 1 Yes Yes No
04/01/2020 B 2 Yes Yes Yes
05/01/2020 A 1 Yes Yes Yes
05/01/2020 A 2 Yes Yes Yes
06/01/2020 A 3 Yes No Yes
07/01/2020 A 4 Yes Yes Yes
08/01/2020 A 5 Yes Yes No
09/01/2020 A 6 Yes Yes Yes