Targeta with Values

[nuriac]

Hello

I have a table with a column that has a calculated measure; and I want to generate another table where the total of that measure appears. I don't understand why I don't get it.

Attached pbix.

VTA Orders Blade; Measure:

VTA1 = SUMX ( SUMMARIZE ( 'SALES ORDERS', 'SALES ORDERS'[Sales Order No], 'SALES ORDERS'[Customer Name], 'SALES ORDERS'[Confirmed Shipping Order] ), [Fact Expected Request] * [INC_VTA_MES1])

Total Sheet.

a table where you can sum the values of VTA1 measures; Month+1

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

[mahoneypat]

I looked at your pbix.  The reason that measure is not working in a card visual is that your measure includes reference to a RANKX measure that will not get a result in the context (for example, the visual does not have the client number).

I did look at one of the measures referenced in your parent measure and provide below a much more efficient way to write it.  I didn't look at the overall approach, but this one measure should be written like this.

INC_VTA_MES1 New =
SWITCH (
    AVERAGEX (
        'MEDIDAS PEDIDOS',
        [rank PED]
    ),
    1, SELECTEDVALUE ( PEDIDO_1_MES_1[Value] ),
    2, SELECTEDVALUE ( PEDIDO_2_MES_1[Value] ),
    3, SELECTEDVALUE ( PEDIDO_3_MES_1[Value] ),
    4, SELECTEDVALUE ( PEDIDO_4_MES_1[Value] ),
    5, SELECTEDVALUE ( PEDIDO_5_MES_1[Value] ),
    0
)

Regards,

Pat

[nuriac]

@mahoneypat've changed the formula to make it more efficient. Thank you

How can I put the VTA1 measure on a table on another sheet and give me the same value? It doesn't work.

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

[mahoneypat]

This is an example of how to write a measure expression to simulate that table visual all in one measure. It uses a SUMMARIZE using the same columns, and then it calculates the VTA1 measure for each row, then sums it all up and should give the same result. You will need to add any of the same visual or page filters from that table to match.

NewMeasure ?
SUMX (
SUMMARIZE (
'SALES ORDERS',
'SALES ORDERS'[Sales Order No],
'SALES ORDERS'[Customer Name],
'SALES ORDERS'[Confirmed Shipping Order]
),
[VTA1]
)

Regards,

Pat

[nuriac]

@mahoneypat doesn't work.

if I add that measure on the sheet where I have the other calculations if it works, but when I add the measure in a table on another sheet (in the TOTAL sheet); gives me 0 values.