i need to create a measure to show the sum just for the values that are #Above the USL (Upper Spec L

[Ayllar]

Hi, i need to create a measure to show the sum just for the values that are #Above the USL (Upper Spec Limit), and another one to show the sum just for the values that are #Below the USL (Upper Spec Limit), needs to be done as a measure becasue the limits varies depending on different selections. The results must be 52 above and 42 below. I alredy try a CALCULATE IF stating the sum the ones that are less than the USL, but it is not working. The USL and LSL vary depending on the filters and diferentes categories.

[1]: https://i.stack.imgur.com/5sje0.png

[Greg_Deckler]

@Ayllar Assuming you have a measure for the Upper Spec Limit, you could do something like this:

Measure = 
  VAR __USL = [USL Measure]
  VAR __Table = FILTER('Table', [Column] > __USL)
  VAR __Result = COUNTROWS( __Table )
RETURN
  __Result

[Ayllar]

Hi @Greg_Deckler i did the suggested formula but is giving the same result 1348 which is the sum of all measures: 

No. Above Specs =

  VAR __USL = [USL After]

  VAR __Table = FILTER(Data, [No. of Ocurrences] > __USL)

  VAR __Result = COUNTROWS( __Table )

RETURN

  __Result