YTD Percentage and month over month percentage

[Bmejia]

I am trying to calculate percent of Profit and I am getting the same value for the overall total (Per Sales). 

Using this calculation to get the overall total to divide each line by. (my denominator 1,965,485.23)

Per Sales =

        CALCULATE(

           [Profit],

            ALL(Main[ITEMID]))

My numerator is the Profit column

Profit = [Purchased Amount]+[Sold Amount]

Purchased Amount =

CALCULATE(

    SUM(

        Main[Cost Amount2]),

        Main[Status Issue] ="SOLD")

Sold Amount =

CALCULATE(

    SUM(

        Main[SALES LINEAMOUNT]),

        Main[Status Issue] ="SOLD")

Need "Per Sales" Column  all to be 1,965,485.23 and % of Sales 2016 9.3%, 2017, 10.4%...

[v-rongtiep-msft]

Hi @Bmejia ,

Please have a try.

Modify your measures.

Per Sales =
SUMX ( ALL ( 'Table' ), [Profit] )

% of Sales=[Profit]/[Per Sales]

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.

Best Regards

Community Support Team _ Polly

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

[Bmejia]

It did not work, I used allexcept and came closer but can't find what other field to exclude.

I was not able to attach a file but here is a link hopefully you can accessed.

https://1drv.ms/u/s!Ah2n-pbAcSl_eugptjdxQuXkMKI?e=CbHMEY