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.

     

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...