Forum Discussion
titus
Helper I
3 years agoHow can i group after summarize
Hello everyone, I have a table “Records” with training hours by worker (badge, course id and hours): badgeID Course Hours 242673 2729 42 173573 2917 4 173573...
- 3 years ago
Built 2 calculated columns and one measure in the data model given.
Columns on tabWorker:
Training Hours Per Worker = CALCULATE( SUM( tabData[Hours] ) )TotalHrs Label = SWITCH( TRUE(), tabWorker[Training Hours Per Worker]<=20, "<=20", tabWorker[Training Hours Per Worker]<30, "<30", tabWorker[Training Hours Per Worker]>=30, ">=30" )Measure:
Worker Cnt = COUNTROWS( tabWorker )give it a thumbs up and accept as solution if this helps!
titus
Helper I
3 years agoExcelent!
THK U so much!
It's great.