How to show data with filters from active and inactive relationship

[dk15]

I'm trying to create a bar chart from data in table 3 and group it by the date in table 1. I want the data in table 3 to include the data from the inactive relationship between table 3 and table 2 and then again, group by the date in table 1. I don't want any data that comes from the relationship with table 4.

I know I could achieve this by smashing some tables together in power query, but I'm curious if there is better way I can do this.

[chrisyan_manalu]

Actually you can dax using "USERELATIONSHIP" to be used in a specific calculation as the one that exists between columnName1 and columnName2

[dk15]

I've seen the USERELATIONSHIP function, but what I've read online and my own experiments don't seem to be doing what I want

[jsaunders_zero9]

Got some sample data?

[dk15]

Here is some example data:

From this example data, I would want a graph with the id's 4, 5 and 6 from table 3, since they both eventually connect back to table 1. id 7 connects to table 2 and then table 4, which I would want to exclude

[v-shex-msft]

HI @dk15,

Your snapshot is too small to get some useful information. Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

In addition, if you want accurate calculations based on specific relationships. You can create an unconnected table and use its field as axis, then you can write a measure formula to lookup and calculation results from raw tables based on the current row context.

Regards,

Xiaoxin Sheng