Need Help with Power Query

[mohitsingh26]

I created a new column to get the monthly average unique users per dashboard:

VAR DashboardDistinctUsers =

    ADDCOLUMNS(

        SUMMARIZE(

            FILTER('raw', NOT(ISBLANK('raw'[Dashboard Name]))),

            'raw'[Dashboard Name],

            'raw'[Date].[Year],

            'raw'[Date].[Month],

            "DistinctUsers", DISTINCTCOUNT('raw'[EMAIL])

        ),

        "YearMonth", DATE([Year], [Month], 1)

    )

VAR AverageDistinctUsersPerDashboard =

    SUMMARIZE(

        DashboardDistinctUsers,

        [Dashboard Name],

        "AvgDistinctUsers", AVERAGEX(DashboardDistinctUsers, [DistinctUsers])

    )

VAR OverallAvgDistinctUsers =

    AVERAGEX(AverageDistinctUsersPerDashboard, [AvgDistinctUsers])

RETURN

    OverallAvgDistinctUser

This gives me the following result:

Now I want to create a new column where if the monthly avg unique users is less than 5.46 (which is the overall average) then the status should be “review relevancy”.
The problem is that I can’t seem to reference that 5.46, not even with a new calculated measure.

e.g. I tried the following:

MEASURE Overall Monthly Average Unique Users =

VAR DashboardDistinctUsers =

    ADDCOLUMNS(

        SUMMARIZE(

            FILTER('raw', NOT(ISBLANK('raw'[Dashboard Name]))),

            'raw'[Dashboard Name],

            'raw'[Date].[Year],

            'raw'[Date].[Month],

            "DistinctUsers", DISTINCTCOUNT('raw'[EMAIL])

        ),

        "YearMonth", DATE([Year], [Month], 1)

    )

VAR AverageDistinctUsersPerDashboard =

    SUMMARIZE(

        DashboardDistinctUsers,

        [Dashboard Name],

        "AvgDistinctUsers", AVERAGEX(DashboardDistinctUsers, [DistinctUsers])

    )

VAR OverallAvgDistinctUsers =

    AVERAGEX(AverageDistinctUsersPerDashboard, [AvgDistinctUsers])

RETURN

    OverallAvgDistinctUsers

How can I reference the total of the table?

[lbendlin]

You say you need help with Power Query?  Or did you mean DAX? 

Note that you cannot create calculated columns from measures.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...