Forum Discussion
Intersect count with filters
Hi uif19085 ,
It seems that you raised another thread with the similar requirement, please find my reply in that thread. And if you have any comment or problem, please update it in that new thread. We will follow it... Thank you.
Count if has a link with filter
Best Regards
Your description is unclear to me. Can you please simplify it?
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
This would be a simplfied version of the Measures i need:
Measure 1: Number of "STR" that have links with one or many EER or SYS = 1 (ArtID 1 has link with an EER or SYS) + 0 (ArtID3 has no link with an EER or SYS) + 1 (ArtID 6 has one link with EER or SYS) + 1 (ArtID 8 has link with an EER or SYS)
Measure 2:
Number of "STR" with implementation in {"implemented"} OR all in-linked "EER" and "SYS" with implementation in {"implemented"}: 1 (ArtID 1 has "implemnted") + 0 ( ArtID 3 "str" with not_implemented and all links are in not_implemented) + 0 (Art 6 "str" with not_implemented and not all links with in implemented, only O-12 is implemented) + 1 (Art 8 "str" not_implemented but all links are in implemented, O-15 and O-12) = 2. Hope it helps. Thanks
No, still unclear. Sorry. Maybe someone else chan chime in.
Hi uif19085 ,
It seems that you raised another thread with the similar requirement, please find my reply in that thread. And if you have any comment or problem, please update it in that new thread. We will follow it... Thank you.
Count if has a link with filter
Best Regards