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

Ohhh that was something I though about but didn't try how to do it. I'm gonna implement that in my report but I think that's going to work 🙂

Thanks!!

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

It works well a solves the problem!!!

Cheers!!