Forum Discussion
Cross Filter Two Tables
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.
3 Replies
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
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 TeamIf 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
Hi,
I tried this but not getting the output correct
