How to Divide Sum Current Category and Total of Category

[Noppadon]

How to Create Messure Divide Sum Current Category and Total of Category. Same Excel Formula as Attach Picture

[Noppadon]

Hi Mariusz,

Result is incorrect. In case i want to divide net sales of men  (gender Category) and Total Net sales of Nike (Brand Category)

---

@Noppadon wrote:

How to Create Messure Divide Sum Current Category and Total of Category. Same Excel Formula as Attach Picture

---

[Mariusz · Accepted solution]

Hi @Noppadon 

Ok, try this.

Sales pct Brand = 
DIVIDE(
    [Sales], --your Measure or Expresion example SUM(SalesTable[Net Sales])
    CALCULATE(
        [Sales], -- again, your Measure or Expresion example SUM(SalesTable[Net Sales])
        ALLSELECTED(),
        VALUES('Product'[Brand]) --Brand Column
    )
)

Regards,
Mariusz

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

[Mariusz]

Hi @Noppadon 

You can use the expression below.

Sales % of Total = 
DIVIDE(
    [Sales], --your Measure or Expresion example SUM(SalesTable[Net Sales])
    CALCULATE(
        [Sales], -- again, your Measure or Expresion example SUM(SalesTable[Net Sales])
        ALL(Sales) -- your table
    )
)

Regards,
Mariusz

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