- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

FILTERING TABLES
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
58 | |
55 | |
55 | |
37 | |
30 |
User | Count |
---|---|
78 | |
64 | |
45 | |
43 | |
40 |