FILTER & CALCULATE

[Anonymous]

Hi Guys,

I have a little issue here...

Considering he following data:

I need to calculate the percentage solded and returned regarding the total of each client for items sold and items returned, how do I configure the "New Column"

Thanks,

I

[v-piga-msft · Accepted solution]

Hi @Anonymous,

It seems that you want to create the calculated column for % sold and % returned.

Please try with the two formulas below.

% sold =
'Table1'[Sell]
    / CALCULATE ( SUM ( 'Table1'[Sell] ), ALLEXCEPT ( Table1, Table1[Client] ) )

% returned =
'Table1'[Reutrned]
    / CALCULATE ( SUM ( 'Table1'[Reutrned] ), ALLEXCEPT ( Table1, Table1[Client] ) )

Here is the output.

If you still need help, please share your desired outout so that we could help further on it.

Best Regards,

Cherry

[dedelman_clng]

Create these as measures:

Pct Sold =
CALCULATE (
    DIVIDE (
        SUM ( Sold[Sell] ),
        SUM ( Sold[Sell] ) + SUM ( Sold[Returned] ),
        0
    )
)


Pct Returned =
CALCULATE (
    DIVIDE (
        SUM ( Sold[Returned] ),
        SUM ( Sold[Sell] ) + SUM ( Sold[Returned] ),
        0
    )
)

Hope this helps

David