topic Re: i need to create a measure to show the sum just for the values that are #Above the USL (Upper Spec L in DAX Commands and Tips

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

Ayllar — Fri, 01 Dec 2023 20:54:31 GMT

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

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

Greg_Deckler — Fri, 01 Dec 2023 21:16:18 GMT

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

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

Ayllar — Mon, 04 Dec 2023 13:45:52 GMT

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