Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

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.

 

1 REPLY 1
bolfri
Solution Sage
Solution Sage

Syndicated - Outbound

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!




avatar user

Helpful resources

Announcements
Join our Fabric User Panel

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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)