Forum Discussion

askoflor's avatar
askoflor
New Member
3 years ago
Solved

COUNT

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

thank

  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.