Need Matrix subtotal to equal the sum of the row totals - and NOT be consistent with formula

[aalok29]

Hey guys, in this matrix, I want "Discipline Projected Revenue" to be equal to the sum of the rows under it, for eg,
Discipline Projected Revenue (at Discipline level) = $300 + $600 + ... = $3,733.33 instead of the displayed $522.94

The formula to calculate Discipline Projected Revenue for the individual projects is as follows:
Discipline Projected Revenue (at Project level) = Discipline Net Fee % of Total * Project Amount

This is correct at project level. But I want the subtotal to be the sum of the Discipline Projected Revenue of the projects, instead of being consistent with the formula.

Here are snippets of all the measure formulas:

Here are the tables:

[Anonymous · Accepted solution]

Hi @aalok29 

You can refer to the following measure

Discipline Projected Revenue (at Project level) =
IF (
    ISINSCOPE ( 'Projection 1'[Project_Name] ),
    [Discipline Net Free % of Total] * [Project Amount],
    SUMX (
        VALUES ( 'Projection 1'[Project_Name] ),
        [Discipline Net Free % of Total] * [Project Amount]
    )
)

Output

Best Regards!

Yolo Zhu

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

[lbendlin]

You need to use aggregation functions like SUMX.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...