Group SUM by single Date

[Anonymous]

Hi everyone,

I'm new to Power BI and Dax and currently I have some Problems with one of my Measures.

I need to count the Days where an Employee booked more than 10 hours workingtime.

The raw Data looks like that. One Employee can book multiple timebits per day.

I tried follwing DAX Expression:

GT10H = CALCULATE(COUNTROWS(DimDate),FILTER(fact_timebits,SUM(fact_timebits[hours])>10))

Of cause the Result is 3, because the total Sum of hours for the three Days is greater than 10. Is there a possibility to only take the daily workingtime into consideration, so i get 1 as result ?

Thanks for your help!!

 

 

[amitchandak]

@Anonymous , Try measures like

Hours =SUM(fact_timebits[hours])
GT10H = CALCULATE(COUNTROWS(DimDate),values(DimDate[date]),FILTER(fact_timebits,[Hours] >10))
sumx(filter(Values(DimDate[date]), [Hours] >10),COUNTROWS(DimDate))

[Fowmy · Accepted solution]

@Anonymous 

Can you try this measure:

GT10H = 
COUNTROWS(
FILTER(
SUMMARIZE(
    fact_timebits,
    fact_timebits[Date],
    "Total", CALCULATE(SUM(fact_timebits[hours]))
),
"Total">10)
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn