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 ...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    How about this...

     

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

    Hope this helps! :smileyhappy:

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

How about this...

 

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

Hope this helps! :smileyhappy:

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

Great thanks !!!