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

Need Help

Anonymous

Not applicable

2 years ago

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