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.
Necesito su ayuda, tengo una columna 1 donde se encuentran montos y un columna 2 donde se encuentran productos, y busco crear una medida que sea el porcentaje de un tipo de producto sobre el total
Producto Monto
A 10
A 10
R 20
A 10
R 15
A 10
el resultado de la medida en este caso para el producto R seria (20+15)/ 75 suma total = 46.6%
Solved! Go to Solution.
Hi @Anonymous,
Please try to use below measure to achieve your requirement:
Measure = DIVIDE ( CALCULATE ( SUM ( Table2[Monto] ), VALUES ( Table2[Producto] ), ALLSELECTED ( Table2 ) ), CALCULATE ( SUM ( Table2[Monto] ), ALLSELECTED ( Table2 ) ), -1 )
Regards,
Xiaoxin Sheng
Hi @Anonymous,
Please try to use below measure to achieve your requirement:
Measure = DIVIDE ( CALCULATE ( SUM ( Table2[Monto] ), VALUES ( Table2[Producto] ), ALLSELECTED ( Table2 ) ), CALCULATE ( SUM ( Table2[Monto] ), ALLSELECTED ( Table2 ) ), -1 )
Regards,
Xiaoxin Sheng
Thanks Xiaoxin, that worked perfect !!!!!
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |