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 ...
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.