Forum Discussion

laurent_rio's avatar
laurent_rio
Icon for Helper I rankHelper I
5 years ago
Solved

How to make filter with select all work for this case ?

Hi,   I have table that have employee name, position, department and training hours  Now i already create several measures  Total Employee = DISTINCTCOUNT('Training Table'[Employee]) Train...
Need Help
Show and Tell
Tips and Tricks
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    laurent_rio 

    You could also do it like this.

     

    Department Average Duration/Staff 2 = 
IF (
    NOT ISBLANK ( [Total Employee] ),
    CALCULATE ( [Average Training Hours/Staff], ALLSELECTED ( 'Training Table' ) )
)

     

     

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
5 years ago

laurent_rio 

You could also do it like this.

 

Department Average Duration/Staff 2 = 
IF (
    NOT ISBLANK ( [Total Employee] ),
    CALCULATE ( [Average Training Hours/Staff], ALLSELECTED ( 'Training Table' ) )
)