Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |