Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Prodigy

## Matrix: Measure Totals Incorrect

Hi all,

I have a matrix with the Values including a measure (measure posted below).

The totals are not showing correctly? Both the subtotals of each row and the bottom grand total.

Is this because of the measure?

Timesheet? = maxx(FILTER('Export Placements','Export Placements'[PlacementStartDate]<=max('Date'[Date]) && (ISBLANK('Export Placements'[PlacementEndDate]) || 'Export Placements'[PlacementEndDate] <=max('Date'[Date]))),'Sheet1'[Timesheet Value])

Cheers

Henry

1 ACCEPTED SOLUTION
Super User

Try like

sumx(summarize(Table,Table[PlacementRec..],Table[CompanyHQ],table[Company Name], Table[Cadidate name],"_1",[Timesheet]),[_1])

Change group by as per need

2 REPLIES 2
Community Support

HI @HenryJS,

I'd like to suggest you can take a look at below blog that shares from @Greg_Deckler, it clearly mentioned the measure total calculation issue and how to fix it:

Measure Totals, The Final Word

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User

Try like

sumx(summarize(Table,Table[PlacementRec..],Table[CompanyHQ],table[Company Name], Table[Cadidate name],"_1",[Timesheet]),[_1])

Change group by as per need

## Helpful resources

Announcements

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors