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

     

     

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

Hi,

This measure works

Measure = if(ISBLANK([Training Duration]),BLANK(),CALCULATE([Average Training Hours/Staff],ALLSELECTED(Department[Department]),all('Training Table'[Position])))

Hope this helps.