DAX - Changing Between SUM and AVERAGE in a Matrix

[ybicalways79]

Help!

I attempted multiple measures to get the results i need.  I can do either SUM or AVERAGE but not both.  Where am i going wrong?

FormatMetric OperationalSales =

VAR Val = SUM ( SalesData[Value] )      

RETURN      

    SWITCH (    

        SELECTEDVALUE ( SalesData[Attribute] ),

        "Overall Sales", FORMAT (Val, "$#,##0;($#,##0)" ),

        "Overall Conversion (%)", FORMAT (Val, "0.0%" ),

        "Overall Margin (%)", FORMAT (Val, "0.0%" ),

        "Overall Lookup (Ct.)", FORMAT (Val, "0" )

)

[tamerj1 · Accepted solution]

Hi @ybicalways79 
Please try

FormatMetric OperationalSales =
VAR Val =
    SUM ( SalesData[Value] )
VAR Ave =
    AVERAGE ( SalesData[Value] )
RETURN
    SWITCH (
        SELECTEDVALUE ( SalesData[Attribute] ),
        "Overall Sales", FORMAT ( Val, "$#,##0;($#,##0)" ),
        "Overall Conversion (%)", FORMAT ( Ave, "0.0%" ),
        "Overall Margin (%)", FORMAT ( Ave, "0.0%" ),
        "Overall Lookup (Ct.)", FORMAT ( Val, "0" )
    )

[ybicalways79]

Thank you!  I was so close on this one!