Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Sum Measure from a aggregated summarize column

Hi all,   I know this could be a basic question, but as I'm new on this Dax I would like to ear from you a solution for my question : I have the follow :      SUMMARIZECOLUMNS(             FTPla...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi , My appologise, 

    My base data is for one use case jobid  95676

     

    JobId  | Potentialhours | Session_StartDate | WeekEndingDateFriday
    95976 | 10.000000        | 2024-09-16           | 2024-09-20
    95976 | 10.000000        | 2024-09-13           | 2024-09-13
    95976 | 10.000000        | 2024-09-17           | 2024-09-20
    95976 | 10.000000        | 2024-09-09           | 2024-09-13
    95976 | 10.000000        | 2024-09-18           | 2024-09-20
    95976 | 10.000000        | 2024-09-04           | 2024-09-06
    95976 | 10.000000        | 2024-09-12           | 2024-09-13
    95976 | 10.000000        | 2024-09-26           | 2024-09-27

    Then I need to Gregate this data per week

     

    JobId  | Potentialhours | WeekEndingDateFriday

    95976 | 10.000000        | 2024-09-20

    95976 | 10.000000        | 2024-09-13

    95976 | 10.000000        | 2024-09-06

    95976 | 10.000000        | 2024-09-27

     

    At the End I would like to get a card with a measure that gives me 40 as total or a total of all jobs ID