Forum Discussion

AliceInChains's avatar
AliceInChains
Frequent Visitor
8 years ago
Solved

Averages not updating when Visualization Filter applied

Hello there,   I have the folloing calculation for MeanDays:   MeanDays = format(INT((average('Property and Admin Unit'[nDays])) / 365), "000") & " Years " & format(INT(divide(Mod((average('Pro...
  • v-huizhn-msft's avatar
    8 years ago

    Hi AliceInChains,

    I haven't see the meandays measure in your screenshot, please add ALLSELECTED(Table) in your formula to create a measure rather than calculated column and check if it works fine.

    MeanDays =
    FORMAT (
        INT (
            (
                AVERAGEX (
                    ALLSELECTED ( 'Property and Admin Unit' ),
                    'Property and Admin Unit'[nDays]
                )
            )
                / 365
        ),
        "000"
    )
        & " Years "
        & FORMAT (
            INT (
                DIVIDE (
                    MOD (
                        (
                            AVERAGEX (
                                ALLSELECTED ( 'Property and Admin Unit' ),
                                'Property and Admin Unit'[nDays]
                            )
                        ),
                        365
                    ),
                    30
                )
            ),
            "00"
        )
        & " Months "
        & FORMAT (
            INT (
                MOD (
                    MOD (
                        (
                            AVERAGEX (
                                ALLSELECTED ( 'Property and Admin Unit' ),
                                'Property and Admin Unit'[nDays]
                            )
                        ),
                        365
                    ),
                    30
                )
            ),
            "00"
        )
        & " Days"
    


    Please respond to us if you have any other issue.

    Best Regards,
    Angelia