No total

[nuriac]

Hello

I'm making a board and one of the measures doesn't total me. The measure that is not totaled is that of VTA 1, VTa 2 and VTA3. The formula is:

VTA1 = [Fact Expected Request]*([INC_VTA_MES1])

[FarhanAhmed]

Looks like you have created a calculated column.  Try to create a Measure

VTA1 = SUMX([Fact Expected Request]*([INC_VTA_MES1]))

[amitchandak]

@nuriac , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[nuriac]

@amitchandak

Attached the file. The problem is that it does not total the VTA1 measures; VTA 2 and VTA3. These measures depend on two other precalculated measures.

I tried the SUMX, but it doesn't work either.

https://drive.google.com/file/d/1HQxO_2dZIPwdoyKqbWoejLptdOPP2xKL/view?usp=sharing

[mahoneypat · Accepted solution]

Use this measurement expression instead for VTA1

New VTA 1
SUMX (
SUMMARIZE (
'SALES ORDERS',
'SALES ORDERS'[Sales Order No],
'SALES ORDERS'[Customer Name],
'SALES ORDERS'[Confirmed Shipping Order]
),
[Expected Order Fact] * [INC_VTA_MES1]
)

Best regards

Pat