Forum Discussion

Puja_Kumari25's avatar
Puja_Kumari25
Icon for Helper III rankHelper III
1 year ago
Solved

Session and Bounce Rate should be filtered based on Country

Hi, "I have two tables in Power BI — Table A with Date, Session, and Channel, and Table B with Date, Bounce Rate, and Channel. I want to filter both datasets by Country, but when I try to load the ...
Need Help
  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    Hi Puja_Kumari25 ,

    Is it linked to Channel or is it linked to  Bounce Rate records directly?

    If possible, build a separate Country lookup table and link by Channel or another common dimension.

    Then, join this to both  Table A and  Table A  via channel.

    Hope this helps!



     

     

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
1 year ago

Hi Puja_Kumari25 ,

 

How does Country relate to the fields in both tables? Is it an attribute of Channel?

What's the source of the data? Is it CSV/XLSX, SQL Server, etc.?

Can your data be aggregated to Week/Channel Group etc. and still meet end user requirements?

 

There's a few possible solutions depending on what the answers to the questions above are.

 

Have a read through this excellent post by Greg to see how you can help us to help you:

How to get your questions answered quickly

 

Pete