COUNT

[askoflor]

Hello, I want to count the number of positive lines of the measure [measure1] -[measure2]

thank

[Anonymous · Accepted solution]

Hi @askoflor ,

Here I create a sample to have a test.

Measures:

Measure 1 = SUM('Table'[Value1])

Measure 2 = SUM('Table'[Value2])

Measure 1 - Measure 2 = [Measure 1] - [Measure 2]

Count Positive = COUNTAX(FILTER(VALUES('Table'[Category]),[Measure 1 - Measure 2] >0),[Category])

 Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.