Forum Discussion

TomBelgium's avatar
TomBelgium
Helper I
3 years ago
Solved

Measure issues

Hi there,

 

I have following data

CustomerSectorNewcustomerTurnover
1Sector 11100
2Sector 10200
3Sector 10300
4Sector 20400
5Sector 20500
6Sector 31600
7Sector 41700
8Sector 40800
   

 

 

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
Sector110%17%
Sector225%0%
Sector317%100%
Sector442%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?
Need Help

2 Replies