Forum Discussion
Solved
Filter and userelationship in same DAX
Hi powerBI community I want to use a filter and the userelationship function in the same meassure. I have tried this and it doesn't work: Rollout = Var network_ = {19,20,21,22,43,44} Re...
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.⚡
Alguém consegue me ajudar na função abaixo, ao digitar o resultado é branco
BACKLOG =
VAR BACKLOG = "VIEW_ORDERS_BACKLOG."
RETURN
CALCULATE([PEDIDOS],
USERELATIONSHIP(dCALENDARIO[DATA],fPEDIDOS[C6_ENTREG]),
FILTER(fPEDIDOS, fPEDIDOS[ORIGEM] IN {BACKLOG}))