Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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 ) )
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
88 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
140 | |
109 | |
68 | |
55 |