cancel
Showing results for
Search instead for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

## Division with condition

I need a dax formulas that bring the % of each day on a month. The condition is: Same type of product. Not all products together. I usually get this with a simple division:

[product type sales of the day]   /  [Sum product type sales of the month]

I tried to use this but without success:

`%ByDay:=DIVIDE(SUM(table[Value];CALCULATE(SUM(table[Value];ALLEXCEPT(table;table[product type])))`

I use only one table, ie there are no relationships with other tables.

Maybe the problem is because there is more than one year/one month, idk.

Expected result

Example 1:

Example 2:

Any help must be apreciated.  Blessings!

1 ACCEPTED SOLUTION
Community Support

Hi @Paulompm,

You can try to use below formula:

```Current of Total= Divide(SUM(Table[Value]),SUMX(All(Table),[Value]),0)

Current of Total(Same Type)=
if(COUNTROWS(Table)<>COUNTROWS(ALL(Table)),
Divide(SUM(Table[Value]),SUMX(FILTER(ALL(Table),Table[Product Type]=max(Table[Product Type])),[Value]),0),1)```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
3 REPLIES 3
Anonymous
Not applicable

Man, what you have feels so correct though!?

`%ByDay:=DIVIDE(SUM(table[Value];CALCULATE(SUM(table[Value];ALLEXCEPT(table;table[product type])))`

Maybe just split it out to help debugging?

`Total Value := SUM(table[Value])Total Value - All In Type := CALCULATE([Total Value], ALLEXCEPT('Table', 'Table'[Product Type]))% in Type := DIVIDE([Total Value], [Total Value - All In Type])`

There is no reason why this should change the result, but just to blow our minds... maybe try:

`Total Value - All In Type := CALCULATE([Total Value], ALL('Table'), VALUES('Table'[Product Type]))`
Community Support

Hi @Anonymous,

I have test on sample file and get the result which he wanted:

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Community Support

Hi @Paulompm,

You can try to use below formula:

```Current of Total= Divide(SUM(Table[Value]),SUMX(All(Table),[Value]),0)

Current of Total(Same Type)=
if(COUNTROWS(Table)<>COUNTROWS(ALL(Table)),
Divide(SUM(Table[Value]),SUMX(FILTER(ALL(Table),Table[Product Type]=max(Table[Product Type])),[Value]),0),1)```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

## Helpful resources

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors