Forum Discussion

Aroth's avatar
Aroth
Icon for Advocate II rankAdvocate II
9 years ago
Solved

Countax counting "zero" values

Hello, 

I have bucketed my consumer according to their sales amount using a measure:

 

It means all my customer are allocated in bucket size.

 

In order to see how many customer I have behind each bucket I used COUNTAX :

 

COUNTAX(Customer;[Bucket Size CY])

 

My problem is : I have some customer that have made sales for "zéro EURO". It means that their is a row with the Name of the customer and on the field "sales " their is "=0"

 

My Countax take in account those customer with zero sales... 

Is it a way to filter this in the countax formula ?

 

Thanks

 

  • How about this...

     

    Measure =
    COUNTAX ( FILTER ( Customer; Customer[Sales] <> 0 ); [Bucket Size CY] )

    Hope this helps! :smileyhappy:

2 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion

    How about this...

     

    Measure =
    COUNTAX ( FILTER ( Customer; Customer[Sales] <> 0 ); [Bucket Size CY] )

    Hope this helps! :smileyhappy: