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.⚡
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.⚡
In a grouped bar chart.
In my axis I have year, quarter, month, week and day which allows drill down.