Forum Discussion

baronraghu's avatar
baronraghu
Helper III
2 years ago

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
baronraghu's avatar
baronraghu
Helper III
2 years ago

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

  • Anonymous's avatar
    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

    • baronraghu's avatar
      baronraghu
      Helper III
      2 years ago

      Hi,

       

      I tried this but not getting the output correct