Power BI表格添加求和、均值、中位值总计行

HTML.表格.多描述总计行 = 
VAR t = VALUES('门店'[门店])
VAR Table_Header = "
    <tr>
        <th>门店</th>
        <th>销售额</th>
        <th>同期销售额</th>
    </tr>"
VAR Table_Value =CONCATENATEX(t,"
    <tr>
        <td>" & [门店] & "</td>
        <td>" & FORMAT([M.销售额],"#,#") & "</td>
        <td>" & FORMAT([M.同期销售额],"#,#") & "</td>
    </tr>",,[M.销售额],DESC) 
VAR Table_Total = "
    <tr class='total'>
        <td>求和</td>
        <td>" & FORMAT([M.销售额],"#,#") & "</td>
        <td>" & FORMAT([M.同期销售额],"#,#") & "</td>
    </tr>
    <tr class='total'>
        <td>均值</td>
        <td>" & FORMAT(AVERAGEX(t,[M.销售额]),"#,#") & "</td>
        <td>" & FORMAT(AVERAGEX(t,[M.同期销售额]),"#,#") & "</td>
    </tr>
    <tr class='total'>
        <td>中位值</td>
        <td>" & FORMAT(MEDIANX(t,[M.销售额]),"#,#") & "</td>
        <td>" & FORMAT(MEDIANX(t,[M.同期销售额]),"#,#") & "</td>
    </tr>"
--以上参数确定表格标题和内容
VAR HTML_Code = "
    <style>
        table {
            font-family: Arial, sans-serif;
            font-size: 16px;
            border-collapse: collapse;
            width: 100%;
        }
        th, td {
            padding: 8px;
            border: 2px solid #ddd;
            word-wrap: break-word;
            text-align: center;
        }
        th {
            background-color: #f2f2f2;
        }
        .total {
            font-weight:bold;
            background-color: #f2f2f2;
        }
    </style>
    <table> " & Table_Header & Table_Value & Table_Total  & "</table>"
RETURN
    HTML_Code