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

Hello Anonymous 
As you've mentioned the A and B are recording so the hours will the sum (4 hours), but in the count of ID = 2, I can see only 2 hours.
Are you looking for something like the below image?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous 

     

    No, the total is not 20, it should be 18. Because the hours at 4/01/21 are 2 not 4.

    My measure is working at a row level, but not for the total that returns infinity, thats my problem.

     

    Thanks!!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello Anonymous 
      Instead of measure try a calculated column and plot into the table.

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