Forum Discussion
DAX help
why does this measure not work? penetration = divide(CALCULATE(sum(Detail[Sales New Used]),Detail[Sales New Used]="New"),SUM('Dealer Summary'[Regs])) sales new used needs to be divided by...
This is the part of my measure which doesnt work
Part 1 = Calculate(SUM('Detail'[Sales New Used]),('Detail'[Sales New Used]="New")
what i need this to do is filter all the New deals and count them up for each business area to then be divided by the RE
Below is all the data required for this measure :
what i need this to do is filter all the New deals and count them up for each business area to then be divided by the RE
Below is all the data required for this measure :
Business area | REGS | Sales new used | penetration |
|
A | 200 | New | (Count of new) ‘New’/REGS |
|
B | 300 | New |
|
|
C | 453 | New |
|
|
A | 200 | Used |
|
|
B | 234 | Used |
|
|
C | 754 | New |
|
|
A | 768 | New |
|
|
Anonymous I have added a sample data table