Forum Discussion

zahirr's avatar
zahirr
Regular Visitor
4 years ago
Solved

Product Rank

I have a survey where we asked in the rank of same products as 5 questions - Rank 1 - A/B/C/D Rank 2 - A/B/C/D Rank 3 - A/B/C/D Rank 4 - A/B/C/D Any easy way to calculate these options A, B, C...
  • rbriga's avatar
    rbriga
    4 years ago

    Alrright, I see what went wrong.

    We need to divide the value by the number of survey IDs:

    Weighted Rank =
DIVIDE(
    SUM( 'Survey'[Rank Value] ),
    CALCULATE(
        COUNTROWS(
            VALUES( Survey[_id] )
        ),
        ALL( Survey[Value] )
    )
)

    Where "value" is actually the category (food, health, etc.).

zahirr's avatar
zahirr
Regular Visitor
4 years ago

Yes, it did!
Thanks a lot for the help 🙂