Forum Discussion
Counting ranks
- 2 years ago
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
- Anonymous2 years ago
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.