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

Reply
HenryJS
Post Prodigy
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])

 

Capture.JPG

 

 

Cheers 

 

Henry

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@HenryJS 

Try like

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

 

Change group by as per need

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
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.
amitchandak
Super User
Super User

@HenryJS 

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

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