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?
