Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX help

Hi,   Below is the data and have expected output as well. I am trying to write DAX expression to get the  Total Trainer Duration  , Trainer Name, No of Student but couldn't success. any h...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    Anonymous 

    pls try this 

    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"))

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

Anonymous 

pls try this 

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"))