Each dealer has four types of contracts they can sell.grouped as OL/CH and HP/FL I need to calc the percentage of all their deals which are OL/CH and HP/FL How can this be done? Other columns which may help are amount financed which is the total financed amount for each deal end result should be John 30% OL/CH 70% HP/FLAmy 24% OL/CH 76% HP/FL

Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. divide( countrows(Table), calculate(countrows(Table), allexcept(Table, Table[Name]))) Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37

This is what it looks like on Excel i need this on power bi

I need the forumla to pick up the dealer and then the columns in the table for each dealer it needs to have the number of contract types it has by the amount financed and then divide the two types of contracts

Anonymous , Based on what I see in excel CH/OL % = divide( sum(Table[CH/OL]), Sum(HP/FL)+sum(Table[CH/OL])) HP/FL % = divide( sum(Table[CH/OL]), Sum(HP/FL)+sum(Table[CH/OL]))

That is closer however, the values CH/OL are in the column called doc type in the data set which is why I need a measure which picks up "ch" and "ol" and calculating all of the amount financed for those

divison calculation for the same column | Microsoft Fabric Community

16 Replies

amitchandak
Super User
5 years ago
Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

divide( countrows(Table), calculate(countrows(Table), allexcept(Table, Table[Name])))

Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37
Anonymous
Not applicable
5 years ago
This is what it looks like on Excel
i need this on power bi
- amitchandak
  Super User
  5 years ago
  Anonymous , Based on what I see in excel
  
  CH/OL % = divide( sum(Table[CH/OL]), Sum(HP/FL)+sum(Table[CH/OL]))
  
  HP/FL % = divide( sum(Table[CH/OL]), Sum(HP/FL)+sum(Table[CH/OL]))
  - Anonymous
    Not applicable
    5 years ago
    That is closer however, the values CH/OL are in the column called doc type in the data set which is why I need a measure which picks up "ch" and "ol" and calculating all of the amount financed for those
Anonymous
Not applicable
5 years ago
I need the forumla to pick up the dealer and then the columns in the table

for each dealer it needs to have the number of contract types it has by the amount financed and then divide the two types of contracts

Forum Discussion

divison calculation for the same column

16 Replies

Related content

TMDL - calculated column

Direct Lake Model - Calculated Column/Tables

IF calculated column

Power Query or Calculated columns

Dynamic Variable in Calculated Columns