Forum Discussion

CiuCiCiao's avatar
CiuCiCiao
Helper I
9 years ago
Solved

Exclude only one value from filtering

Hi Guys, I have 2 linked tables. the first has the time in minutes spent for the FTEs for all the services provided: Time Services m Office Service 1                              206 ...
Tips and Tricks
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi CiuCiCiao,

     

    To exclude Service 6 from the returned value, you can create a measure like below:

     

    Measure = CALCULATE(SUM('Time'[m]),FILTER('Time','Time'[Office]=MAX('FTE'[Office]) && 'Time'[Services]<>"Service 6"))/60

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi CiuCiCiao,

 

To exclude Service 6 from the returned value, you can create a measure like below:

 

Measure = CALCULATE(SUM('Time'[m]),FILTER('Time','Time'[Office]=MAX('FTE'[Office]) && 'Time'[Services]<>"Service 6"))/60

 

 

Best Regards,
Qiuyun Yu