DAX Formula to create a final rating for satisfaction rating

DAX DAX Calculations
1

Hello

Rating calculation.xlsx (12.7 KB)

I need help with the DAX formula for the attached excel sheet.

I have survey results with ratings of Very Dissatisfied, Dissatisfied, Neutral, Satisfied, and Very Satisfied. I want to be able to show an overall/final rating (3.72 in yellow highlight). Can you please help/guide me on how to write the dax formula?

2

@BM_Girlracer ,

Please give this a go:

Rating Score =

VAR TotalCount =
    CALCULATE (
        SUM ( Data[Count] ),
        REMOVEFILTERS ( Data )
    )
VAR vTable =
    ADDCOLUMNS (
        Data,
        "@Pct",
            DIVIDE (
                Data[Count],
                TotalCount,
                BLANK ()
            )
    )
VAR vTable2 =
    ADDCOLUMNS (
        vTable,
        "@FinalRtg",
            Data[Rating Score] * [@Pct]
    )
VAR Result =
    SUMX (
        vTable2,
        [@FinalRtg]
    )
RETURN
    Result

image

I hope this is helpful. Full solution file attached below.

3

Thanks Brian! :slight_smile: