Forum Discussion
Filter and userelationship in same DAX
ThomasWeppler it should work, how you are visualizing the data:
Rollout = Var network_ = {19,20,21,22,43,44} Return CALCULATE (COUNT ( 'Projects'[id] ), USERELATIONSHIP(Calender[Date], Projects[Deadline]), Projects[Projecttype] IN network_, Projects[C HP-Status] = "HP DONE")✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
So in the end I just used the Userelationship and added the filters in the filter colon and made them hidden so they won't distract the end user.
It works which is awesome, but it means that I will have to add the extra filters on each visualization so it is not as elegant a solution as I would have hoped for. But I think it will have to do for now.