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 Team,
I have sample data like this
Index | No Series |
0 | 025010-025010 |
1 | 025132-025132 |
2 | |
3 | |
4 | |
5 | |
6 | 027019-027019 |
7 | |
9 | |
10 | |
11 | 027086-027086 |
12 | |
13 | |
14 | |
15 | |
16 | |
17 |
I need to create one new column with count of rows group wise (last column) by using DAX
Index | No Series | Need to count rows for each group |
0 | 025010-025010 | 1 |
1 | 025132-025132 | 5 |
2 | ||
3 | ||
4 | ||
5 | ||
6 | 027019-027019 | 4 |
7 | ||
9 | ||
10 | ||
11 | 027086-027086 | 7 |
12 | ||
13 | ||
14 | ||
15 | ||
16 | ||
17 |
Thanks
Solved! Go to Solution.
Weird, the index column is not contiguous. I correct it so that a simple FIRSTNONBLANKVALUE() does the trick.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Weird, the index column is not contiguous. I correct it so that a simple FIRSTNONBLANKVALUE() does the trick.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi PijushRoy
Thanks for reaching out for help
Try this ..
In Power Query click on No Series and Fill.
This will popoulate the empty columns.
The create a DAX measre
Rowcount = COUNTROWS(yourtablename)
The on an emoty report canvas annd table visual with
pPease click the thumbs up and accept solution button, thank you
No, it will nor work @speedramps
for Countrows for each row will generate only 1.
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |