Forum Discussion

Just2431's avatar
Just2431
Helper I
2 years ago
Solved

Help with measurement

Hello all,   The calculation i found online didn't work so i thought i will try here. I am new to power bi. I have 2 colums in my bi, one with time spent and another with diffrent operation type (m...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,

    Greg_Deckler , thanks for your concern about the problem, and i want to offer some more information for user to refer to.

    hello Just2431 , based on your description, you just need to create the following measure

    Measure = CALCULATE(SUM('Table'[Time Spent]),ALLEXCEPT('Table','Table'[Operation]))

    Output

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Just2431's avatar
Just2431
Helper I
2 years ago

Greg sorry about that! this is the sample data

trying to achieve this 

 

i am trying to sum all the diffrent categories from column 2. I think i need to use Pivit column but not sure what excatly I need to do. Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

    Greg_Deckler , thanks for your concern about the problem, and i want to offer some more information for user to refer to.

    hello Just2431 , based on your description, you just need to create the following measure

    Measure = CALCULATE(SUM('Table'[Time Spent]),ALLEXCEPT('Table','Table'[Operation]))

    Output

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Just2431's avatar
      Just2431
      Helper I
      2 years ago

      Anonymous Thank you so much for your help!! it does what i wanted to do!! I used a similar measure but it didnt work becasue my "time spent" column was swet as text not number...