Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Matrix calculation

Hi All, I dervied matrix table like below. This data contains each month requested, resolved incidents count.  from below i need total unresolved incident count on each month .  Example  During Apri...
Need Help
Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

Create a Calendar Table and link it to your data table


Create the following Measure to calculate the Unresolved Tickets

Unresolved incidents = 
VAR _MonthEnd = MAX(Dates[Date]) RETURN
COUNTROWS(
    FILTER(
        ALLSELECTED(Incidents),
        Incidents[Requested Date] <= _MonthEnd && Incidents[Resolved Date] >= _MonthEnd
    )
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Anonymous's avatar
Anonymous
Not applicable
5 years ago
_MonthEnd returns 31 dec 2020, so not able to get count between months.  Note : I have ticket January to sep for now