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
shaykoooo
Helper I
Helper I

CALCULATE and COUNTROWS

Hi,
If I am interested to count how many customers have purchased 250 $ and above, will the following measure do the trick?
Measure:= CALCULATE,(COUNTROWS(Fact_Table), Fact_Table[Sales_Amount]>=250)

Thanks!
2 ACCEPTED SOLUTIONS
AlB
Super User
Super User

Hi @shaykoooo

If there's only one row per customer in your fact table then it would work. Otherwise it wouldn't.

View solution in original post

v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @shaykoooo,

 

As AlB said, if your table is like below, the measure you mentioned should work.

 

count.PNG

 

If you still need help, please share some data sample which could  reproduce your scenario so that we could help further on it.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @shaykoooo,

 

As AlB said, if your table is like below, the measure you mentioned should work.

 

count.PNG

 

If you still need help, please share some data sample which could  reproduce your scenario so that we could help further on it.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AlB
Super User
Super User

Hi @shaykoooo

If there's only one row per customer in your fact table then it would work. Otherwise it wouldn't.

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.