dax measure help

[Anonymous]

Hi,
so I need to create a dax measure which calculates the percentage of deal type for each category.
calculation is 
Total number of Hire Purchase + Finance lease / Total amount financed for each category.

Hire purchase and Finance lease are just the values in the deal type column.

Not sure exactly how to format it 

[PC2790]

Try this:

Column = DIVIDE(MyTable[Amount financed],CALCULATE(SUM(MyTable[Amount financed]),ALLEXCEPT(MyTable,MyTable[Doc Type])))

and in Column Tools -->Format section, mark the column as Percentage.

The result will look something as below:

[ryan_mayu]

@Anonymous 

could you pls provide some sample data and expected output?

[Anonymous]

Doc Type	Amount financed
HP	343
FL	54
HP	3
FL	56
OH	57547
HP	67568
FL	568756

I need to count all the Hire Purchase and all the Finance lease and then divide them by the total amount financed for those deals only.
to give me a percentage of the deals which are that type of lease. 

[ryan_mayu]

@Anonymous 

is this what you want?

Measure 2 = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Doc Type]="HP" ||'Table'[Doc Type]="FL"))/COUNTROWS('Table')

[Anonymous]

Yeah but I need it to be divided over the amount financed total for all those deals, do i do that in a separate measure

[ryan_mayu]

@Anonymous 

i am not familiar to finance staff. could you pls let me the expected output and calculation logic based on your sample data?

[Anonymous]

So what i need is to count the number of HPs and Finance lease. Eg = 10 
in those 10 the amount financed totals to 150.

I need to divide the 10 by 150 to show as a percentage

then i will add this to its own table and also to a table with the sales people who have issued out these contracts 

[ryan_mayu]

@Anonymous 

maybe change the countrows to sum(amount)

Measure 2 = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Doc Type]="HP" ||'Table'[Doc Type]="FL"))/sum(amount)

[Anonymous]

okay that seems to work

now if i want to add another part to it which tells me what percentage of the deals are now Operating lease and Contract Hire do i just make a new calculation or add it onto that?

[ryan_mayu]

@Anonymous 

maybe try to remove the condition in the filter.

It's better to provide the expected output, not just wording it. Since we don't know your real business. Only providing words may cause misunderstanding.

[Greg_Deckler]

@Anonymous Easiest way would be to create your measure:

Measure = Hire Purchase + Finance lease / Total amount

Then right click the measure in the visual's Values field well and choose Show as and then Percent of grand total