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 Regs but only the 'new' must be totaled and divided.
11 Replies
Anonymous
maybe you can try to saparate the DAX to two parts and check which part didn't return the expected result.
CALCULATE(sum(Detail[Sales New Used]),Detail[Sales New Used]="New")
SUM('Dealer Summary'[Regs])
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 :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
is this what you want?
Column = CALCULATE(COUNT('Table'[Sales new used]),FILTER('Table','Table'[Business Area]=EARLIER('Table'[Business Area])&&'Table'[Sales new used]="New"))