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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Frequent Visitor

Multiple Tables Filtering and Relationships

I have two seperate tables one a climate with month and evap data, and the other table with month and a factor based from products.

The climate table has a relationship with the site overview table and is filtering out climate data based on a region from a filter selection in site overview. The other table has a relationship with areas (a seperate table) wich is also filtered from a relationship with the site overview table and brings up muliutple products with the multiple factors for each month. 

I need to calculate the effect that the product factor has on the evaporation though cant create a relationship between the two tables because of ambiguity, is there a way to acheive what i am after, hoping that it makes sense

Community Support
Community Support

Hi @sustainhort ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.


Best regards,
Community Support Team_Binbin Yu

Example Data 

Current relationships Site Overview ID - Paddocks ID

Site Overview location- climate location

Paddocks product ID-crop factor product ID

output calculate between these factors for one graph essentially



Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.