The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a table trying to count different attainments:
This is the table I have:
Rank |
>75% |
>75% |
>75% |
0%-25% |
0%-25% |
0%-25% |
0%-25% |
0%-25% |
0%-25% |
0%-25% |
0%-25% |
25%-50% |
25%-50% |
50%-75% |
50%-75% |
50%-75% |
50%-75% |
50%-75% |
50%-75% |
and this is the table I'm trying to get:
Rank | >75% | 0%-25% | 25%-50% | 50%-75% |
Count | 3 | 8 | 2 | 6 |
How do I create a measure to accomplish that?
Solved! Go to Solution.
Thank you Jihwan,
Unfortunately that would not work for me, as I have other columns too.
Example:
Category Achieved
A >75%
B >75%
C 0%-25%
D 0%-25%
E 0%-25%
F 25%-50%
H 50%-75%
So I need to speciafy the column within the table
Hi @Thunders ,
Please use this DAX:
Measure =
CALCULATE(
COUNTROWS('Table'),
ALLEXCEPT(
'Table',
'Table'[Rank]
)
)
If I add other columns:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Jihwan,
Unfortunately that would not work for me, as I have other columns too.
Example:
Category Achieved
A >75%
B >75%
C 0%-25%
D 0%-25%
E 0%-25%
F 25%-50%
H 50%-75%
So I need to speciafy the column within the table
Hi @Thunders ,
Please use this DAX:
Measure =
CALCULATE(
COUNTROWS('Table'),
ALLEXCEPT(
'Table',
'Table'[Rank]
)
)
If I add other columns:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Please check the below picture and the attached pbix file.
COUNTROWS function (DAX) - DAX | Microsoft Learn
Count measure: =
COUNTROWS('Table')
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
32 | |
15 | |
12 | |
12 | |
7 |