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.
Hi,
I have a table/list ("Performance") where one of the columns ("Occupancy") contains some values that'll be added to give me a total.
Table: Performance (for Department C)
Column1 | Column2 | Column3
xxx | 20 | xxx
xxx | 50 | xxx
xxx | 40 | xxx
There's another table ("Targets") that contains a list of targets for particular department:
NameofDepartment | Target
Dept_A | 120
Dept_B | 200
Dept_C | 140
I'm doing a report for Dept C and would like to display 110/140 as a Gauge or other visual (sum of Performance[Column2] / Target value for Dept C in the Targets table?
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
You will need these two measures to get the picture below.
Let me know if you have any questions,
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Sum of Dept C Performance = SUM('Performance Dept C'[Col 2]) Target for Dept C = CALCULATE(MAX('Name of Department'[Target]),'Name of Department'[Name of Department]="Dept_C")
Proud to be a Super User!
Hi @Anonymous ,
You will need these two measures to get the picture below.
Let me know if you have any questions,
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Sum of Dept C Performance = SUM('Performance Dept C'[Col 2]) Target for Dept C = CALCULATE(MAX('Name of Department'[Target]),'Name of Department'[Name of Department]="Dept_C")
Proud to be a Super User!
@Anonymous ,
Or you could make the target the max value for this picture.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |