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.
I'm using a excel file to house montly data. Each month has a differant total hours of capcity. In my report I'm using a Multi-Card to show the total hours within a month or within a quarter. Currently it's showing me a total of all the rows for all months. I need to be able show just the total of three rows of capacity data in the mulitcard when filtred down to a specific month or quarter.
Solved! Go to Solution.
@Anonymous
Give these measure a try. You would put these in your multi row card.
Working Hours Measure =
AVERAGEX (
VALUES ( 'Enterprise Utilization'[Name] ),
CALCULATE ( SUM ( 'Enterprise Utilization'[Working Hours (h)] ) )
)
Capacity Measure =
AVERAGEX (
VALUES ( 'Enterprise Utilization'[Name] ),
CALCULATE ( SUM ( 'Enterprise Utilization'[Capacity (h)] ) )
)
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
@Anonymous
If you select that user in the chart is the amount in the multi row card not filtered to just the numbers for that user?
@jdbuchanan71 can you replace the screen shot or snip it with out the individuals names?
@Anonymous
If you pick that user in your name slicer what amounts show in thr card?
@jdbuchanan71, can you replace the screen shot or snip it with out the individuals names?
@Anonymous
Any chance you can share your .pbix (upload it to OneDrive or DropBox and share the link)?
let me check what my security protocol is there. 🙂
Done but also, your new screen shot does not show all blanks for that user. What changed and is that the expected result?
@Anonymous
Give these measure a try. You would put these in your multi row card.
Working Hours Measure =
AVERAGEX (
VALUES ( 'Enterprise Utilization'[Name] ),
CALCULATE ( SUM ( 'Enterprise Utilization'[Working Hours (h)] ) )
)
Capacity Measure =
AVERAGEX (
VALUES ( 'Enterprise Utilization'[Name] ),
CALCULATE ( SUM ( 'Enterprise Utilization'[Capacity (h)] ) )
)
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |