Counting positive and negative values from the measure.

[Anonymous]

Hello,

I have created a Table visualization in the power bi report.

The visualised table contains Company name from the power bi table fields (Company) <- Collumn.
And the rest are the measures (images for reference below). Is there a way i can count postive and negative measurements? I would need a count of measurements that are positive and a count that are negative. Etc.

Thank you for the help.

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try this Measure

CountPositives =
COUNTX (
    FILTER ( ALLSELECTED ( Companies[Company] ), [DynamicMonth] > 0 ),
    [DynamicMonth]
)

[Anonymous]

Zubair_Muhammad works like a charm.
Thank you very much.
Did count by hand when the values were filtered by year etc. Works great!