Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor


Good Afternoon, community.
I'll try to be as clear as I can (english isn't my native language).
I have these two tables prod_diaria_obras and metas_eqp_obras.


In the first table (prod_diaria_obras) I have 4 columns : Date, Team, Daily Productivity and Acumulated Goal.

In the second table (metas_eqp_obras) I have 4 columns as well: Team, Year, Month, Monthly Goal.


The monthly goal of a team can changes a lot and in a single year the same team could have 3 or 4 goals values. 


What I'm trying to accomplish:
I'm building this report and I want to display, in addition to charts, card containing 3 values: GOAL, ACUMULATED GOAL and PRODUCTIVITY. In this report I also have 3 slicers: YEAR, MONTH and (a slider) DATE


What I'm struggling with:

I want the sum of GOAL to be adjusted dynamically according to the filtered years/months.

So, let's say that the months 2 and 3 of the year 2022 are filtereds, I want to display the sum of GOAL for that period and the ACUMULATED GOAL and PRODUCTIVITY could be adjusted by the slider.


It seems easy but I'm really struggling with it. Can someone, please, help me with this issue?
Thanks in advance.


Best regards, Marcio Mendonça.


Solution Sage
Solution Sage

Can you please provide some basic, sample data and expected results? Excel would be great, but not nessesery. It can be eg 2-3 teams and they fake results.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors