Forum Discussion

AdamOrmond's avatar
AdamOrmond
Frequent Visitor
8 years ago
Solved

Cannot get desired Matrix visualization subtotals and totals

I'm working on building a matrix visualization showing employee time expenditures against assigned contract hours. For instance, Jennifer Smith has been assigned hours across three contracts. Each da...
Need Help
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
8 years ago

AdamOrmond

 

Hi, try with this measure:

 

M-ContractHours.Assigned Hours =
IF (
    HASONEVALUE ( TimeCardContractHoursMerged[Date] ),
    BLANK (),
    AVERAGE ( TimeCardContractHoursMerged[ContractHours.Assigned Hours] )
)

Regards

Victor

AdamOrmond's avatar
AdamOrmond
Frequent Visitor
8 years ago

Unfortunately that does not produce the desired output. It does show the average value for the day, 25 for Jennifer/Alpha, but the total values for the employee and across all employees do not add up. This is the desired result looks something like this for Jennifer Smith:

 

Employee Hours WorkedAssigned Hours
Jennifer Smith 11585
Alpha 1825
 Friday, May 410 
 Saturday, May 58 
Beta 3220
 Monday, May 77 
 Monday, May 86 
 Monday, May 911 
Delta 3340

 

 

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    8 years ago

    AdamOrmond

     

    Hi, review the Attached PBIX Page 4. Is very close of the expected result.

     

    Regards

     

    Victor

    • AdamOrmond's avatar
      AdamOrmond
      Frequent Visitor
      8 years ago

      Thanks, Vvelarde! The TREATAS function was what I needed.