Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
Ojesim
Regular Visitor

Count rows in a fact table based on a column and a column in a dat table

have an IT helpdesk table that has one of its colums as Status(closed as ID 1 , open as ID 2, Inprogress as ID 3).

 

I created a date table with Year(2020, 2021, 2022, 2023), Qtr and month columns.

 

I want to calculate how many Closed tickets we have based on the ticket status and year 2023.

 

I tried CALCULATE(COUNT(table[status]), FILTER (Table, Table[status]] = 1 && Date[Year] = 3 but it's not working. 

 

My model looks okay, it's all 1 to many relationships. 

 

Someone pls help me and also explain the concept as well. 

 

Thank you