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.
Business area | REGS | Sales new used | penetration |
|
A | 50 | New | (Count of new) ‘New’/REGS |
|
B | 30 | New |
|
|
C | 106 | New |
|
|
A | 200 | Used |
|
|
B | 234 | Used |
|
|
C | 224 | New |
|
|
A | 768 | New |
|
|
This is all the data required for the Pen dax measure
I need to count all the new and divide it by the amount of Regs
Solved! Go to Solution.
Hi @Anonymous ,
Did @amitchandak 's formula solve your problem? I can get the correct result using the formula:
Does it match your desired output? If your problem is solved, please consider accept amitchandak's answer as the solution to help the other members find it more quickly.
Best Regards,
Winniz
Hi @Anonymous ,
Did @amitchandak 's formula solve your problem? I can get the correct result using the formula:
Does it match your desired output? If your problem is solved, please consider accept amitchandak's answer as the solution to help the other members find it more quickly.
Best Regards,
Winniz
@Anonymous , Try like
calculate(divide(countrows(Table), sum(Table[REGS])),filter(table,Table[Sales new used] = "New"))
@Anonymous , Try measure like
divide(countrows(filter(table,Table[Sales new used] = "New")), sum(Table[REGS]))
Business Area | REGS | Sales New used | Pen |
|
|
|
A | 968 | 2 | 2/968=0.002 |
|
|
|
B | 300 | 1 |
|
|
|
|
C | 1207 | 2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This is what the result should be
so if the deliveries are 100 and the New units are 50 altogther
then (50/100) x 100 for %
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |