Forum Discussion
titus
Helper I
Helper IHow 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...
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!
titusHelper I
Helper IThk you YukiK for your time.
That's not quite.
without wishing to waste your time i share my pbix and source:
https://1drv.ms/u/s!AgewLjPenPlMi99JTVSFLze50JbHyg?e=4BXUmI
(i'm not able to attach any file)
everything is working fine, but i'm stuck in that measure: how many workers by Total Training hours category
Again, thk U YukiK
YukiK
Impactful Individual
Impactful IndividualBuilt 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!