Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
why does this measure not work?
Solved! Go to Solution.
@Anonymous
because denominatordenominator is 0.
you can use DIVIDE
Proud to be a Super User!
Hi @Anonymous ,
Might because of the denominator. Try:
penetration = divide(CALCULATE(sum(Detail[Sales New Used]),Detail[Sales New Used]="New"),Calculate(SUM('Dealer Summary'[Regs]),All('Dealer Summary'))
If it doesn't work, please show some sample data and expected result.
Best Regards,
Jay
This is the part of my measure which doesnt work
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"))
Proud to be a Super User!
this is what i want
Business Area | REGS | Sales New used | Pen |
|
|
|
A | 968 | 2 | 2/968=0.002 |
|
|
|
B | 300 | 1 |
|
|
|
|
C | 1207 | 2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Why am i getting infinity and values over 100%
@Anonymous
I suggest you check regs and count. You mean the business area have the results for regs and count, but result is infinity?
Proud to be a Super User!
yes
@Anonymous
because denominatordenominator is 0.
you can use DIVIDE
Proud to be a Super User!
@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])
Proud to be a Super User!
User | Count |
---|---|
114 | |
71 | |
57 | |
46 | |
39 |
User | Count |
---|---|
173 | |
121 | |
58 | |
58 | |
56 |