COUNT

askoflor — Mon, 20 Mar 2023 12:29:47 GMT

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

thank

Re: COUNT

Anonymous — Wed, 22 Mar 2023 07:10:41 GMT

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.