Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
74 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |