Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hola a todos
Estoy fresco a BI, tengo un problema con el cálculo delta de una columna.
Tengo un maeasure para calcular el conteo para cada rango.
¿Puede alguien ayudar a calcular el delta de la siguiente puntuación de fila.
Gracias de antemano
rango | Contar | Puntuación | Delta |
1 | 2416 | 244 | 76(244-168) |
2 | 1870 | 168 | 43 |
3 | 1826 | 125 | 23 |
4 | 1667 | 102 | 21 |
5 | 1609 | 81 | 52 |
6 | 1080 | 29 | 8 |
7 | 939 | 21 |
Solved! Go to Solution.
@KiranGupta15, es posible que desee ajustar la medida de esta manera
Delta =
VAR __next_rank = MAX ( 'Table'[Rank] ) + 1
VAR __next_score =
CALCULATE (
[Score],
'Table'[Rank] = __next_rank,
ALL ( 'Table' )
)
RETURN
IF ( NOT ISBLANK ( __next_score ), [Score] - __next_score )
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hola @KiranGupta15
¿Podría decirme si su problema ha sido resuelto? Si es así, acédi es la solución. Más gente se beneficiará de ello. O todavía está confundido al respecto, por favor proporcione más detalles sobre su problema o compártame con su archivo pbix de su Onedrive for Business.
Saludos
Rico Zhou
Hola, @KiranGupta15, puedes probar esta medida
Delta =
VAR __next_rank = MAX ( 'Table'[Rank] ) + 1
VAR __next_score =
CALCULATE (
MAX ( 'Table'[Score] ),
'Table'[Rank] = __next_rank,
ALL ( 'Table' )
)
RETURN
IF ( NOT ISBLANK ( __next_score ), MAX ( 'Table'[Score] ) - __next_score )
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Gracias señor....
Mi "Puntuación" es una Medida, no una columna en la tabla.
"La columna 'Puntuación' en la tabla 'Tabla' no se puede encontrar o no se puede utilizar en esta expresión."
Este es el mensaje de error ...:
@KiranGupta15, es posible que desee ajustar la medida de esta manera
Delta =
VAR __next_rank = MAX ( 'Table'[Rank] ) + 1
VAR __next_score =
CALCULATE (
[Score],
'Table'[Rank] = __next_rank,
ALL ( 'Table' )
)
RETURN
IF ( NOT ISBLANK ( __next_score ), [Score] - __next_score )
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |