Penetration dax measure

[Anonymous]

Business area	REGS	Sales new used	penetration
A	50	New	(Count of new) ‘New’/REGS
B	30	New
C	106	New
A	200	Used
B	234	Used
C	224	New
A	768	New

This is all the data required for the Pen dax measure 

I need to count all the new and divide it by the amount of Regs

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

Did @amitchandak 's formula solve your problem? I can get the correct result using the formula:

     

Does it match your desired output? If your problem is solved, please consider accept amitchandak's answer as the solution to help the other members find it more quickly.

Best Regards,
Winniz

[amitchandak]

@Anonymous , Try like

calculate(divide(countrows(Table), sum(Table[REGS])),filter(table,Table[Sales new used] = "New"))

[amitchandak]

@Anonymous , Try measure like

divide(countrows(filter(table,Table[Sales new used] = "New")), sum(Table[REGS]))

[Anonymous]

Business Area	REGS	Sales New used	Pen
A	968	2	2/968=0.002 x 100 = 0.2%
B	300	1
C	1207	2

This is  what the result should be 

so if the deliveries are 100 and the New units are 50 altogther 

then (50/100) x 100 for %