Aggregate count based on two columns using DAX (column/measure)?

[olimilo]

I have the following data. On the left is a table that contains the issues of each member of the team and the date when the issue was found. I would like to get an aggregate (count rows) of these issues in the main Data table (on the right) based on the Name and the Date columns. The Issues and Data table are indirectly related via a Calendar table.

I'm able to do this by using Power Query but it's taking way too long so I was wondering if this is possible using DAX?

[v-xuding-msft · Accepted solution]

Hi @olimilo ,

Please try the formula below.

Column = 
CALCULATE (
 COUNT ( Issue[Issue] ) + 0,
 FILTER ( Issue, Issue[Name] = Data[Name] && Issue[Date] = Data[Date] )
)

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.