Forum Discussion
clustered column
Welcome !! Good luck with your Power BI Journey.
as per the relationship diagram, you have two relations and for your knowledge, you can have only one active relationship between the same tables, in your case, the solid line shows the active relationship and the dotted line shows the inactive relationship. So any time you visualize the data, it will use an active relationship, to use an inactive relationship, you have to create a measure and then in that measure make an inactive relationship active:
Sum Due Date = SUM ( Table[Amount] ) //this will use active relationhip
Sum Original Due Date =
CALCULATE (
[Sum Due Date],
USERELATIONSHIP ( Table[Original Due Date], DueDateTable[Due Date] ) //this will make inactive relationship to active
)
use these measures in the visual and it will work as expected.
✨ 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.⚡
Thanks parry2k. Where do I put these 'measures' - in the main table or the 'due_sort' table?
(and if you don't mind - for my own understanding - what are the two measures doing in a Power BI sense? I am really new with all this).
kind regards...
