Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I'm having trouble with this one. Im looking to show productivity to a static goal, but i want to be able to show the overall percentage to goal (for all departments) by month or by single day depending on what the user chooses.
my data looks something like this:
Main table:
Date Department Productivity
1/1/2019 8:01AM 1 .47
1/1/2019 8:06AM 2 .50
1/2/2019 11:00AM 1 .80
Goal table:
Department Goal
1 .9
2 .6
Any help would be greatly appreciated.
Solved! Go to Solution.
You may try the measure below.
Measure = AVERAGEX ( VALUES ( 'Main'[Department] ), CALCULATE ( VAR d = SELECTEDVALUE ( Main[Department] ) RETURN DIVIDE ( SUM ( Main[Productivity] ), LOOKUPVALUE ( 'Goal'[Goal], 'Goal'[Department], d ) ) ) )
Can you please provide an example with the expected result in both cases? What happens when a month is selected? an average of the productivity over all days in that month?
I'm sorry, yes the average % to goal for the month for all deparments (or whichever one is selected)
You may try the measure below.
Measure = AVERAGEX ( VALUES ( 'Main'[Department] ), CALCULATE ( VAR d = SELECTEDVALUE ( Main[Department] ) RETURN DIVIDE ( SUM ( Main[Productivity] ), LOOKUPVALUE ( 'Goal'[Goal], 'Goal'[Department], d ) ) ) )
THANK YOU SO MUCH!! This has been driving me crazy. Again, thank you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |