Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Aroth
Advocate II
Advocate II

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

 

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

How about this...

 

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

Hope this helps! Smiley Happy

View solution in original post

2 REPLIES 2
Sean
Community Champion
Community Champion

How about this...

 

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

Hope this helps! Smiley Happy

Great thanks !!!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.