Forum Discussion
Calculate sum using different relationships based on condition
Hello everyone, I'm trying to build a rather complicated DAX measure but I have no luck getting the expected the result. Here's a simplified description of my data: I have a table that contains ...
Hello lbendlin,
I edited the message to include HTML tables. You can also find an example with the expected result.
lbendlin
Super User
Super UserI think we're missing the Company table
Not sure where you are going with the is_switched but likely you can use inactive relationships.
The company table is just a simple dimension:
company_id name 1 company 1 2 company 2
The is_switched column indicated whether the active or inactive relationship should be used to calculate the total sum and for which top_name and name to display the value in a visual. Please review my question and examples. It explains the purpose of the is_switched column.
I'm already using inactive and active relationships.- lbendlin
I reviewed your questions and examples and I don't understand the logic. I hope someone else can help you further.