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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
DeepDive
Helper IV
Helper IV

Unable to Count of calculation made using measure ?

Hi Experts,

I have two columns available with me i.e. Name and Sales. Now I have calculated Rank_sales and Rank_bucket using Measures.
Now my requirement how to calculated count of Rank_Buckets against respective buckets (using measure only)

PS:
Rank_Sales = Rank of Sales
Rank_Bucket = put ranks in bucket as per requirement


Pls also help with any blog or tutorial on how we can use measures further in other calculations

 

NameSalesRank_SalesRank_BucketCount o fRank_Bucket - Respective To Bucket
X324114
Z200214
Y123314
W100414
V90526
J63626
I62726
L56826
R56826
G551026
S4511310
U4212310
D3413310
K3413310
Q3413310
E3316310
H3316310
F2318310
O2318310
T2318310
N122146
P122146
M92346
C62446
A52546
B32646
1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

Hello @DeepDive 

Give this a try.

Count of Rank Bucket = 
VAR _bucket = [Rank_Bucket]
RETURN
COUNTROWS (
    FILTER ( ALL( YourTable[Name] ) , [Rank_Bucket] = _bucket ) )

RankBucket.jpg

View solution in original post

2 REPLIES 2
jdbuchanan71
Super User
Super User

Hello @DeepDive 

Give this a try.

Count of Rank Bucket = 
VAR _bucket = [Rank_Bucket]
RETURN
COUNTROWS (
    FILTER ( ALL( YourTable[Name] ) , [Rank_Bucket] = _bucket ) )

RankBucket.jpg

@jdbuchanan71 Thank you.. Working fine

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors