Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
baronraghu
Helper III
Helper III

Cross Filter Two Tables

Hi All,

 

I have three tables as shown below

1. States (Bridge table)

2. PNG_032024

3. CGD_ Basic 

 

baronraghu_0-1718705183385.png

 

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)

baronraghu_1-1718705312618.png

However, the filter is not giving correct result.

3 REPLIES 3
baronraghu
Helper III
Helper III

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

Hi,

 

I tried this but not getting the output correct

baronraghu_0-1718878432645.png

 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.