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
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. ðŸ˜…

      • 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 )