Calculation of Total in Dynamic table

[Syndicate_Admin]

I have a dynamic table where my values are the average sale per day of the week.

PromedioDia = Divide(sum(TablaVentas[CEO]),COUNT(Calendar[OrdDiaL]))

I calculate them are well my problem is the total because I want it to be the sum of all the fil

1,240,602

[Syndicate_Admin]

Thank you

[Anonymous]

Hi @Syndicate_Admin ,

According to your statement, I think your requirement is to sum the meausre in total. I suggest you to try SUMX() function in your measure.

Sum =
SUMX (
    SUMMARIZE (
        'TableName',
        'TableName'[Year],
        'TableName'[Level2],
        'TableName'[Level3]
    ),
    [PromedioDia]
)

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Syndicate_Admin , Based on Level you can do Avg of Sum and Switch using isinscope

Avg of Sum : https://youtu.be/cN8AO3_vmlY?t=22980

How to Switch Subtotal and Grand Total in Power BI | Power BI Tutorials: https://youtu.be/smhIPw3OkKA