cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iHickUp Regular Visitor
Regular Visitor

Counting positive and negative values from the measure.

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.


1.PNG2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Counting positive and negative values from the measure.

@iHickUp

 

Try this Measure

 

 

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

 

Try my new Power BI game Cross the River

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Counting positive and negative values from the measure.

@iHickUp

 

Try this Measure

 

 

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

 

Try my new Power BI game Cross the River

View solution in original post

iHickUp Regular Visitor
Regular Visitor

Re: Counting positive and negative values from the measure.

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

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,433)