Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 ) )
User | Count |
---|---|
134 | |
68 | |
68 | |
54 | |
52 |
User | Count |
---|---|
207 | |
95 | |
64 | |
61 | |
57 |