How can I create a dax that will let me calculate specific rows of data for a multicard?

[Anonymous]

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.

[jdbuchanan71]

@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?

[Anonymous]

@jdbuchanan71 can you replace the screen shot or snip it with out the individuals names?

[Anonymous]

@jdbuchanan71 the amont is filtered to just that user.

[jdbuchanan71]

@Anonymous 

If you pick that user in your name slicer what amounts show in thr card?

[Anonymous]

@jdbuchanan71, can you replace the screen shot or snip it with out the individuals names?

[Anonymous]

[jdbuchanan71]

@Anonymous 

Any chance you can share your .pbix (upload it to OneDrive or DropBox and share the link)?

[Anonymous]

let me check what my security protocol is there. 🙂

[jdbuchanan71]

Done but also, your new screen shot does not show all blanks for that user.  What changed and is that the expected result?

[Anonymous]

This is the the accurate data for the user chosen. We'd like to see the Working Hours and Capacity show these values since they are the total for each user instead of it showing the total in second snap shot.

[jdbuchanan71 · Accepted 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.