Forum Discussion

Aztec's avatar
Aztec
Frequent Visitor
8 years ago

Statistics based on predefined period in another table

Hi, I need to create incidents statistics occurred in a predefined period for :- i) Incident count by period ii) Backlog by period iii) Backlog completed by period   So, there is a Period table...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

Aztec,

 

You may refer to the following measures.

IncidentCount =
COUNTROWS (
    FILTER (
        Incident,
        Incident[RaisedDate] < SELECTEDVALUE ( PeriodTable[EndDate] )
            && Incident[Closed Date] >= SELECTEDVALUE ( PeriodTable[StartDate] )
    )
)

Backlog =
COUNTROWS (
    FILTER (
        Incident,
        Incident[RaisedDate] < SELECTEDVALUE ( PeriodTable[StartDate] )
            && Incident[Closed Date] >= SELECTEDVALUE ( PeriodTable[StartDate] )
    )
)

BacklogCompleted =
COUNTROWS (
    FILTER (
        Incident,
        Incident[RaisedDate] < SELECTEDVALUE ( PeriodTable[StartDate] )
            && Incident[Closed Date] >= SELECTEDVALUE ( PeriodTable[StartDate] )
            && Incident[Closed Date] < SELECTEDVALUE ( PeriodTable[EndDate] )
    )
)