Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

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?  
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    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:

    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's avatar
jdbuchanan71
Super User
6 years ago

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:

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.