Cross Filter Two Tables

[baronraghu]

Hi All,

I have three tables as shown below

1. States (Bridge table)

2. PNG_032024

3. CGD_ Basic 

I am building a visual in which when i select the state all the area in the state shows up with PNG Target (Sum of PNG target on CGD Basic table ) and Domestic connection given (Sum of Domestic column in PNG-032024 table)

However, the filter is not giving correct result.

[baronraghu]

One way i am able to do is by making the relationship between state and PNG_032024 inactive and building a relationship between (GA name of CGD Basic and GA name of PNG_032024 one to one bi-directional)

Just wanted to know if there could be any better way of doing it using a dax fucntion

[v-cgao-msft]

Hi @baronraghu ,

Please try:

Total Domestic Connection given =
CALCULATE (
    SUM ( 'PNG_032024'[Domestic] ),
    TREATAS ( VALUES ( 'CGD_ Basic'[States] ), 'PNG_032024'[States] )
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[baronraghu]

Hi,

I tried this but not getting the output correct