Measure issues

[TomBelgium]

Hi there,

I have following data

Customer	Sector	Newcustomer	Turnover
1	Sector 1	1	100
2	Sector 1	0	200
3	Sector 1	0	300
4	Sector 2	0	400
5	Sector 2	0	500
6	Sector 3	1	600
7	Sector 4	1	700
8	Sector 4	0	800

I already have a measure of how many percent a turnover of a sector represents again the total turnover but I also want to measure how many of the turnover of the sector is new within that sector. 
So I should get the following:

	% turnover	%new turnover
Sector1	10%	17%
Sector2	25%	0%
Sector3	17%	100%
Sector4	42%	47%

I have measure which works for the first one: 

Procentueel = DIVIDE (

SUM ( PBIInvoice_Info[Total_Invoiced] ),

CALCULATE (

SUM (PBIInvoice_Info[Total_Invoiced] ),

ALL ( PBIInvoice_Info[SectorRFID] )

),

0

)

I thought to just add a new measure with the newcustomercolumn but this doesn't seem to do the trick.

Procentueel = DIVIDE (

SUM ( PBIInvoice_Info[Total_Invoiced] ),

CALCULATE (

SUM (PBIInvoice_Info[Total_Invoiced] ),

ALL ( PBIInvoice_Info[SectorRFID] , NEWCUSTOMERCOLUMN)

),

0

)

Any suggestions?

[mangaus1111 · Accepted solution]

Hi @TomBelgium ,

see my pbi file

https://1drv.ms/u/s!Aj45jbu0mDVJi03x0HQTiKnyfBoW?e=YvQ6KG

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

[TomBelgium]

Thanks Mangaus. Works as it should. If you have an answer to this also: Re: Lead conversion rate: how to visualize and mak... - Microsoft Power BI Community

By my guest 😉