How to Multiply rows in a table visualization

Question

Hello guys,&nbsp;i have a table, that the result in percentage is a measure (have column). i want to multiply the first row with all below as follows:&nbsp;The want column is the multiplication of the have as follow:&nbsp;&nbsp;i have no ideia how i can do that. Can you guys help me? Thanks

parry2k · Answer

Gionedis&nbsp;I assume you have sort or key column for each bucket, if not you need to add one and then write following measure:
&nbsp;
New Measure = 
VAR __MyKey = SELECTEDVALUE ( Test[Key] )
VAR __Table = FILTER ( ALL ( Test ), Test[Key] &gt; __MyKey )
RETURN
PRODUCTX ( 
    __Table, [My Measure] * 1 
) + 0
&nbsp;
and here is the output
&nbsp;

&nbsp;

gionedis · Answer

Hello, i think im foing it wrong: for the bucket i created a column ordering:

then replicated your dax formula:

the result was 0:

for instance, the roll rate NBV measure is something like this:

it goes until the Write-Off

Thanks

anonymous · Answer

Hi&nbsp;Gionedis&nbsp;,
&nbsp;
Please try code as below.
New =
VAR _SUMMARZIE =
    SUMMARIZE (
        ALL ( 'tfat_carteira' ),
        'tfat_carteira'[CC_AGING],
        'tfat_carteira'[AgingValue],
        "Roll Rate NBV", [Roll Rate NBV]
    )
VAR _PRODUCT =
    ADDCOLUMNS (
        _SUMMARIZE,
        "PRODUCT",
            PRODUCTX (
                FILTER ( _SUMMARIZE, [AgingValue] &gt; EARLIER ( [AgingValue] ) ),
                [Roll Rate NBV]
            )
    )
RETURN
    SUMX (
        FILTER ( _PRODUCT, [CC_AGING] = MAX ( 'tfat_carteira'[CC_AGING] ) ),
        [PRODUCT]
    )
&nbsp;
Best Regards,Rico Zhou
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

gionedis · Answer

Hello,&nbsp;this time return empty.&nbsp;below the formula:here the define:&nbsp;DEFINE
    MEASURE '_Medidas'[Roll Rate NBV] = // Calculate the total NBV
VAR cc = CALCULATE(SUM(tfat_carteira[NBV]),tfat_carteira[CC_STATUS_CHANGE] IN {"ROLOU-1-30","ROLOU","ROLLBACK"})

// Get the selected aging value
VAR aging = SELECTEDVALUE(tfat_carteira[CC_AGING])

RETURN
    SWITCH (
        aging,
        "2) 1-30",
            IFERROR(
                cc / CALCULATE(
                    SUM(tfat_carteira[NBV]),
                    tfat_carteira[CC_AGING] = "1) On Date",
                    FILTER(
                        ALL(tdim_tempo),
                        tdim_tempo[INDEX_ANO_MES] = MAX(tdim_tempo[INDEX_ANO_MES]) - 1
                    )
                ),
                BLANK()
            ),
        "3) 31-60",
            IFERROR(
                cc / CALCULATE(
                    SUM(tfat_carteira[NBV]),
                    tfat_carteira[CC_AGING] = "2) 1-30",
                    FILTER(
                        ALL(tdim_tempo),
                        tdim_tempo[INDEX_ANO_MES] = MAX(tdim_tempo[INDEX_ANO_MES]) - 1
                    )
                ),
                BLANK()
            ),
        "4) 61-90",
            IFERROR(
                cc / CALCULATE(
                    SUM(tfat_carteira[NBV]),
                    tfat_carteira[CC_AGING] = "3) 31-60",
                    FILTER(
                        ALL(tdim_tempo),
                        tdim_tempo[INDEX_ANO_MES] = MAX(tdim_tempo[INDEX_ANO_MES]) - 1
                    )
                ),
                BLANK()
            ),
        "5) 91-120",
            IFERROR(
                cc / CALCULATE(
                    SUM(tfat_carteira[NBV]),
                    tfat_carteira[CC_AGING] = "4) 61-90",
                    FILTER(
                        ALL(tdim_tempo),
                        tdim_tempo[INDEX_ANO_MES] = MAX(tdim_tempo[INDEX_ANO_MES]) - 1
                    )
                ),
                BLANK()
            ),
        "6) 121-150",
            IFERROR(
                cc / CALCULATE(
                    SUM(tfat_carteira[NBV]),
                    tfat_carteira[CC_AGING] = "5) 91-120",
                    FILTER(
                        ALL(tdim_tempo),
                        tdim_tempo[INDEX_ANO_MES] = MAX(tdim_tempo[INDEX_ANO_MES]) - 1
                    )
                ),
                BLANK()
            ),
        "7) 151-180",
            IFERROR(
                cc / CALCULATE(
                    SUM(tfat_carteira[NBV]),
                    tfat_carteira[CC_AGING] = "6) 121-150",
                    FILTER(
                        ALL(tdim_tempo),
                        tdim_tempo[INDEX_ANO_MES] = MAX(tdim_tempo[INDEX_ANO_MES]) - 1
                    )
                ),
                BLANK()
            ),
        "8) WOFF",
            IFERROR(
                cc / CALCULATE(
                    SUM(tfat_carteira[NBV]),
                    tfat_carteira[CC_AGING] = "7) 151-180",
                    FILTER(
                        ALL(tdim_tempo),
                        tdim_tempo[INDEX_ANO_MES] = MAX(tdim_tempo[INDEX_ANO_MES]) - 1
                    )
                ),
                BLANK()
            )
    )
    MEASURE '_Medidas'[New] = VAR _SUMMARIZE =
    SUMMARIZE (
        ALL ( 'tfat_carteira' ),
        'tfat_carteira'[CC_AGING],
        'tfat_carteira'[AgingValue],
        "Roll Rate NBV", [Roll Rate NBV]
    )
VAR _PRODUCT =
    ADDCOLUMNS (
        _SUMMARIZE,
        "PRODUCT",
            PRODUCTX (
                FILTER ( _SUMMARIZE, [AgingValue] &gt; EARLIER ( [AgingValue] ) ),
                [Roll Rate NBV]
            )
    )
RETURN
    SUMX (
        FILTER ( _PRODUCT, [CC_AGING] = MAX ( 'tfat_carteira'[CC_AGING] ) ),
        [PRODUCT]
    )

EVALUATE
    SUMMARIZECOLUMNS(
        "Roll Rate NBV", '_Medidas'[Roll Rate NBV],
        "New", '_Medidas'[New]
    )&nbsp;thanks&nbsp;

Forum Discussion

How to Multiply rows in a table visualization

4 Replies

Related content

export from visual table

Table visual error

Table Visual not Matching Calculated Visual

Multiply two tables

Table Visual Sorting