DAX help

Question

Hi,&nbsp;Below is the data and have expected output as well. I am trying to write DAX expression to get the&nbsp;Total Trainer Duration&nbsp; ,Trainer Name,No of Studentbut couldn't success. any help would be much appreciated.&nbsp;Data&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IDusernameCategoryDuration&nbsp;&nbsp;101JohnTrainer60&nbsp;&nbsp;101TomStudent20&nbsp;&nbsp;101ChrisStudent30&nbsp;&nbsp;101WilsonStudent40&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Expected Output&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IDusernameCategoryTotal Trainer DurationTrainer NameNo of Student101JohnTrainer60John3101TomStudent60John3101ChrisStudent60John3101WilsonStudent60John3&nbsp;

ryan_mayu · Accepted Answer

Anonymous&nbsp;
pls try this&nbsp;
Measure = CALCULATE( sum('Table'[Duration]),FILTER(all('Table'),'Table'[Category]="Trainer"))

Measure 2 = maxx(FILTER(all('Table'),'Table'[Category]="Trainer"),'Table'[username])

Measure 3 = CALCULATE( COUNTROWS('Table'),FILTER(all('Table'),'Table'[Category]="Student"))

Forum Discussion

DAX help

2 Replies

Related content

Dax

DAX

DAX Behavior

DAX Formula Help

DAX

Data
ID	username	Category	Duration
101	John	Trainer	60
101	Tom	Student	20
101	Chris	Student	30
101	Wilson	Student	40


Expected Output
ID	username	Category	Total Trainer Duration	Trainer Name	No of Student
101	John	Trainer	60	John	3
101	Tom	Student	60	John	3
101	Chris	Student	60	John	3
101	Wilson	Student	60	John	3