How to create a column flag in a table of grouped data

[Anonymous]

Hi,

I'm relatively new to PowerBI and DAX and I have the following problem. I've searched on this forum and internet, but the problem is I don't know where to start.

I have a simple Timestamp table which contains information regarding the tasks of employees. This includes start date, duration, end date etc.

I have a table visualisation in PowerBI that summarises each day and the total duration time of tasks. For example:

Count is the number of tasks performed in the specified date.

I need to create a count of each day that has over 100 hours and summarise this at the bottom. How would I do this?

Thanks

[Anonymous]

I've managed to solve part of the problem by creating the following measure:

Hour10Tst = IF(Sum(tFact_DateTime[Duration_hours])>=100,1,0)

This could then be filtered if necessary. However, the count at the bottom of the table is obviously incorrect, as this should be 2. See below.

Alternatively to the table, I could just also see a Card visualisation with the total number of days over 100 hours.

[Anonymous]

Hi @Anonymous,

Create a new column using the following formula. Then create table visual and card visual as shown in the followings screenshot

Column = IF(tFact_DateTime[Duration_hours]>=100,1,0)

Thanks,
Lydia Zhang