Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
| Name | Sales | Rank_Sales | Rank_Bucket | Count o fRank_Bucket - Respective To Bucket |
| X | 324 | 1 | 1 | 4 |
| Z | 200 | 2 | 1 | 4 |
| Y | 123 | 3 | 1 | 4 |
| W | 100 | 4 | 1 | 4 |
| V | 90 | 5 | 2 | 6 |
| J | 63 | 6 | 2 | 6 |
| I | 62 | 7 | 2 | 6 |
| L | 56 | 8 | 2 | 6 |
| R | 56 | 8 | 2 | 6 |
| G | 55 | 10 | 2 | 6 |
| S | 45 | 11 | 3 | 10 |
| U | 42 | 12 | 3 | 10 |
| D | 34 | 13 | 3 | 10 |
| K | 34 | 13 | 3 | 10 |
| Q | 34 | 13 | 3 | 10 |
| E | 33 | 16 | 3 | 10 |
| H | 33 | 16 | 3 | 10 |
| F | 23 | 18 | 3 | 10 |
| O | 23 | 18 | 3 | 10 |
| T | 23 | 18 | 3 | 10 |
| N | 12 | 21 | 4 | 6 |
| P | 12 | 21 | 4 | 6 |
| M | 9 | 23 | 4 | 6 |
| C | 6 | 24 | 4 | 6 |
| A | 5 | 25 | 4 | 6 |
| B | 3 | 26 | 4 | 6 |
Solved! Go to Solution.
Hello @DeepDive
Give this a try.
Count of Rank Bucket =
VAR _bucket = [Rank_Bucket]
RETURN
COUNTROWS (
FILTER ( ALL( YourTable[Name] ) , [Rank_Bucket] = _bucket ) )
Hello @DeepDive
Give this a try.
Count of Rank Bucket =
VAR _bucket = [Rank_Bucket]
RETURN
COUNTROWS (
FILTER ( ALL( YourTable[Name] ) , [Rank_Bucket] = _bucket ) )
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 70 | |
| 50 | |
| 42 | |
| 40 |