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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
ARK8
New Member

How to count rows of column after a filter expressions (not using calculate)

Table Customer 

 

Customer KeyCustomer Type
1L
2S
3L
4S

 

Sales Table 

Sale QtySale priceCustomer ID
5021
2052
10103
100304
20083

 

I am trying to count distinct customers for a particular type  who made sale using Filters (strictly not by calculate) 
 So far I came up with this : 

    FILTER ( Sales,

                  Related(Customer[CustomerType] = "L"

               )

 not sure who do I go from here.

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @ARK8 

Please try

Count =
COUNTROWS (
SUMMARIZE (
FILTER ( Sales, RELATED ( Customer[CustomerType] ) = "L" ),
Customer[Customer Key]
)
)

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

Hi @ARK8 

Please try

Count =
COUNTROWS (
SUMMARIZE (
FILTER ( Sales, RELATED ( Customer[CustomerType] ) = "L" ),
Customer[Customer Key]
)
)

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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