Forum Discussion
olimilo
Post Prodigy
Post ProdigyAggregate count based on two columns using DAX (column/measure)?
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 iss...
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.
v-xuding-msft
Community Support
Community SupportHi 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.