Forum Discussion
Related
Hi amitchandak
The Relationship meets at another table. But I figured out there was another table i could make a relation with (a date table) and after that, i used the relatedtable function with sumx and that worked out with a charm. But good to know: userelationship.
Hi PaulDBrown
Thanks for the reply. Since I could use the relatedtable function with sumx, everything works fine. But that's a great way with a virtual table.
Anonymous , Why the relationship is inactive?
You can activate it using userelationship https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi
related need active relation
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.