Forum Discussion
Maintenance Tracking - What am I missing?
I was hoping someone might be able to help me start on this. I’m trying to create a few dashboards for our Operational teams to track maintenance being done. We have a master list of all maintenance...
Anonymous To get a list of checks that have never been completed, you can do something like this:
Measure = VAR __MassterList = DISTINCT( 'Maintenance Check Master List'[MtcCheck] ) VAR __Completed = DISTINCT( 'Completed Maintenance Checks'[MtcCheck] ) VAR __Table = EXCEPT( __MasterList, __Completed ) VAR __Result = COUNTROWS( __Table ) RETURN __Result
Anonymous To get a list of checks that have never been completed, you can do something like this:
Measure =
VAR __MassterList = DISTINCT( 'Maintenance Check Master List'[MtcCheck] )
VAR __Completed = DISTINCT( 'Completed Maintenance Checks'[MtcCheck] )
VAR __Table = EXCEPT( __MasterList, __Completed )
VAR __Result = COUNTROWS( __Table )
RETURN
__ResultGreg_Deckler Thanks Greg! This helps!