Forum Discussion
Multiple filtering in the measure
- Anonymous1 year ago
Hi Patriklat ,
Thanks for reaching out to our community.
Based on your description, I think you want to count rows from defects group by names from loaded.
Here's my solution.
1.Create two columns, and then you can create a relationship between tables.
2.Create a measure to count rows and create a table visual with the name field and the measure.
As you can see, John Doe has 13 to repair.
If my solution is incorrect, feel free to contact me~
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Patriklat ,
You can try something simillar to this:
Defect Counter: CALCULATE(
COUNT('Defects'[KB]),
FILTER('Defects', [KB] = 135))
John Doe Repairs: CALCULATE(
COUNT('Loaded'[BodyID]),
FILTER('Loaded', [Name] = "John Doe" &&
[Direction] = 2)
)