Count column per category on basis of values from measure

[Anonymous]

Hello, 

I have a dummy table as below:

Diff value is not a column but a calculated measure.

What I need is a table as below:

So on basis of measure  "Diff value", I want to calculate count of elements that have value >5.

I am trying to work with below DAX:

Count = SUMMARIZE(table ,table[ElementName],"Count DiffValue>5",

'Measure'[Diff Value]).

The above code is not working and it gives error as below:

Is there another method to group by on basis of values from a measure?

[Ahmedx]

[johnt75 · Accepted solution]

Try

Count Diff Value > 5 =
VAR SummaryTable =
    ADDCOLUMNS (
        SUMMARIZE ( 'Table', 'Table'[Element], 'Table'[Coordinates] ),
        "@diff value", [Diff value]
    )
VAR Result =
    COUNTROWS ( FILTER ( SummaryTable, [@diff value] > 5 ) )
RETURN
    Result