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.
Hola
Me gustaría saber cómo calcular la relación de cada fila dividida por la suma de las mismas filas dentro de un grupo utilizando la columna calculada.
saludos
projectskey | fiscalPeriod | Distribución de pronósticos | Suma de distribución de pronósticos | Factor |
1299647 | 202001 | 0.01 | 1.23 | 0.00813 |
1299647 | 202002 | 0.04 | 1.23 | 0.03252 |
1299647 | 202003 | 0.08 | 1.23 | 0.065041 |
1299647 | 202004 | 0.15 | 1.23 | 0.121951 |
1299647 | 202005 | 0.22 | 1.23 | 0.178862 |
1299647 | 202006 | 0.22 | 1.23 | 0.178862 |
1299647 | 202007 | 0.22 | 1.23 | 0.178862 |
1299647 | 202008 | 0.15 | 1.23 | 0.121951 |
1299647 | 202009 | 0.08 | 1.23 | 0.065041 |
1299647 | 202010 | 0.04 | 1.23 | 0.03252 |
1299647 | 202011 | 0.01 | 1.23 | 0.00813 |
1299647 | 202012 | 0.01 | 1.23 | 0.00813 |
1301420 | 202001 | 0.01 | 1.15 | 0.008696 |
1301420 | 202002 | 0.04 | 1.15 | 0.034783 |
1301420 | 202004 | 0.15 | 1.15 | 0.130435 |
1301420 | 202005 | 0.22 | 1.15 | 0.191304 |
1301420 | 202006 | 0.22 | 1.15 | 0.191304 |
1301420 | 202007 | 0.22 | 1.15 | 0.191304 |
1301420 | 202008 | 0.15 | 1.15 | 0.130435 |
1301420 | 202009 | 0.08 | 1.15 | 0.069565 |
1301420 | 202010 | 0.04 | 1.15 | 0.034783 |
1301420 | 202011 | 0.01 | 1.15 | 0.008696 |
1301420 | 202012 | 0.01 | 1.15 | 0.008696 |
Solved! Go to Solution.
Hola @alepage ,
Tratar
Column = 'Table'[Forecast Distribution]/CALCULATE(SUM('Table'[Forecast Distribution]),ALLEXCEPT('Table','Table'[projectskey]))
Saludos
Jay
@alepage ,
utilizar todos excepto
Ejemplo
calculate(sum(Table[column),allexcept(Table,Table[projectskey]))
Además, consulte
https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390
Aquí está el Dax que me da los resultados de la 5a columna.
Hola @alepage ,
Tratar
Column = 'Table'[Forecast Distribution]/CALCULATE(SUM('Table'[Forecast Distribution]),ALLEXCEPT('Table','Table'[projectskey]))
Saludos
Jay
Este Dax me da la 4a columna . Me pregunto si es posible dividir la 3a columna por la 4a columna para obtener los resultados que se muestran en la 5a columna sin generar una dependencia circular.
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 |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |