Forum Discussion

Thunders's avatar
Thunders
Frequent Visitor
2 years ago
Solved

Counting ranks

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% ...
  • Thunders's avatar
    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

     



  • Anonymous's avatar
    Anonymous
    2 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.