Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Countax with selectedvalue expresion returns Zero

Hi I started with this thread wondering how to solve the issue. From there I got to a solution with a DAX meassure but it's not working for the totals. I got this table: Actor Time Start Time...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello Anonymous 
    Create a calculated column using the below calculation.

    Hour =
    VAR TotalID =
    CALCULATE ( COUNT ( Recordings[ID] ), ALLEXCEPT ( Recordings, Recordings[ID] ) )
    RETURN
    DIVIDE ( [TotalHours], TotalID )

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yep I think that a good one, but I don't know how to do that calculation in a column. ðŸ˜…

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello Anonymous 
Create a calculated column using the below calculation.

Hour =
VAR TotalID =
CALCULATE ( COUNT ( Recordings[ID] ), ALLEXCEPT ( Recordings, Recordings[ID] ) )
RETURN
DIVIDE ( [TotalHours], TotalID )

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Wow That's it!!! Modify the time in a new column allows me to calculate speed metrics by actor and conten type, not just by content type 😄

    Amazing!!!

     

    Thanks a lot for your help!