Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
4 years ago

IF Statement

Hi,   I have the following code that works just fine when calculating the difference between Case Start & Case End when there is only 1 row of data, but when there are 2 row the total is doubled: 2...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

ArchStanton , I think to do the total use summarize of values

 

Sumx(Values(Table[TIcket No]), [measure Total case length ])

  • ArchStanton's avatar
    ArchStanton
    Power Participant
    4 years ago

    Hi, 

    I don't follow, what Values are you referring to in your example?

    I tried a number of combinations and none of them work.

    Also, I'm not using a measure because when I do I get the wrong result - I need a row context for this.

    I would like to keep this as a calculated column if possible?

     

    Thanks,