Share via

Measure grand total

Pedro Quiroz 0 Reputation points
2025-01-13T20:35:23.1966667+00:00

Hi community, I work with report builder, I trying to calculate grand total, but I don't make a correct calculation. The Source is actually semantic model in power bi service, I have on semantic model this dimensions: Country, City and measures : stock, orders, average.

Stock and orders are "SUM(Measure)" so for the grand total is OK.

But the measure "average" is in fact, DIVIDE ( orders , stock ) function defined on model,

so Do I need a aggregation for grand total? Which?

It is possible to use this measure instead of expression?

thanks in advance.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,970 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 39,496 Reputation points
    2025-01-14T02:22:33.6933333+00:00

    Hi @Pedro Quiroz，

    The issue is related with PBI service and DAX command.

    You may raise the issue to PBI side to get more professional advice.

    DAX Commands and Tips - Microsoft Fabric Community

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.