Forum Discussion

ankit3977's avatar
ankit3977
Frequent Visitor
2 years ago

Need to pull data by personwise with combine data

Hello

I want to pull out data by person who has done projects in Level 1, Level 2, level 3 and Level 4. In that, Some projects were done only Level 1, Some were done by Levels 1 & 2. Some projects are processed by only two people on different levels. Refer below snap for data set

 

 

 

As per above snap person worked on task 1, task 2 and task 3 as well. Now I need to pull all data by person but when this data was pulled Task 2 person pulled our data then that club Task 1 + task data and same line when that pull out data for Task 3 ( person wise) then that pull out Task 1+ task 2 +task 3.  Like when report pulls out data for Karan then that pull-out data 280+40 =320 and also pulls and clubs with total number of Karan when he worked on Task 1 level. So this means When Metric pulls for Kran then that shows 160 (task 1)  +  320 (280+40) = 480 total logs.

 

So please guide me how we can pull out this data by person-wise.

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    ankit3977 , You might have try a meausre like

     

    CumulativeValueByPerson =
    CALCULATE(
    SUM('Table'[Value]),
    FILTER(
    ALL('Table'),
    'Table'[Person] = max('Table'[Person]) &&
    'Table'[Task] <= Max('Table'[Task])
    )
    )

     

     

    Also, you have to consider isinscope to switch measure

     

    IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM