Forum Discussion

Lakka00's avatar
Lakka00
Frequent Visitor
2 years ago

Time totals

I have a table which records the number of times someone is late and the time. I need it to be a count of lates and then in the last column the total time for the rows counted.   Below is how it is...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
2 years ago

Thanks Lakka00 

 

Here's a PBIX file with the solution

 

 

I had to modify the DAX measure for the Late Count as your column names were different to what I originally had

 

Count Lates = CALCULATE(COUNTROWS('DataTable'), FILTER(ALL('DataTable'), 'DataTable'[Late?] ="yes" && 'DataTable'[Title] = SELECTEDVALUE('DataTable'[Title])))

 

Regards

 

Phil

Lakka00's avatar
Lakka00
Frequent Visitor
2 years ago

Hi, thank you. However I cannot open the file due to incompatible version types, I will try get mine updated but I am assuming I will not be able to due to IT restrictions. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Lakka00 ,

    I think your solution is great, PhilipTreacy . It worked like a charm! I think you can update your Power BI Desktop version and try to open the .pbix file provided by PhilipTreacy below.

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.