Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |