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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
HenryJS
Post Prodigy
Post Prodigy

Matrix: Measure Totals

Hi all,

 

I have placed the 'Actual Timesheets' measure shown below into a matrix value.

 

The total isn't correct? How can I get it to total correctly?

 

Capture.PNG

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

Hello @HenryJS 

What is throwing you off is the thinking that the total column has anything to do with the individual date columns.  Your formula is calculating correctly in the context of no date:

2020-06-20_8-11-14.png

If you want the total column to sum the amount from the individual days you will need the change it to a SUMX formula.

Actual Timesheets = SUMX ( VALUES ( <your date column here> ), [Unique Workers] - [Unique Workers] * [Holiday (%)] )

There is no need for the ( ) around the [Unique Workers] * [Holiday (%)] part of the formula, multiplication is calculated before subtraction.

View solution in original post

4 REPLIES 4
jdbuchanan71
Super User
Super User

Hello @HenryJS 

What is throwing you off is the thinking that the total column has anything to do with the individual date columns.  Your formula is calculating correctly in the context of no date:

2020-06-20_8-11-14.png

If you want the total column to sum the amount from the individual days you will need the change it to a SUMX formula.

Actual Timesheets = SUMX ( VALUES ( <your date column here> ), [Unique Workers] - [Unique Workers] * [Holiday (%)] )

There is no need for the ( ) around the [Unique Workers] * [Holiday (%)] part of the formula, multiplication is calculated before subtraction.

@jdbuchanan71 Thanks for your help. That worked.

 

How can I change the value to a whole number? Currently it is showing as a decimal number to 2 points.

 

 

@HenryJS yes you can either change as @jdbuchanan71 or keep your existing measure and refer it in the new measure, logic is the same, 

 

to change the format, select the measure, you will see measure tools on the menu and that's where you can change the decimal to 0 or change it to the whole number.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

@HenryJS add new measure and use that

 

New Measures = 
SUMX ( VALUES ( Table[Date Column] ), [Actual Timesheet] )

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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