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 a todos!
Estamos teniendo el mejor momento para obtener un tipo correcto en nuestro DAX.
La tabla siguiente tiene una columna creada en DAX denominada Total acumulativo. Lo que estamos haciendo es crear un total acumulado del porcentaje. El problema es que la columna LineUtilization está realizando el total y realmente queremos que lo realice la columna LineHours (para la que hemos creado un rango). Nuestro problema es no importa cómo intentemos cambiar la parte ISONORAFTER('V_PBI_WO55_DETAILS'[LineUtilization],MAX('V_PBI_WO55_DETAILS'[LineUtilization]),DESC) seguimos recibiendo mensajes de error. Queríamos tener ese ISONORAFTER para usar el Ranking o el LineHours, pero seguimos recibiendo mensajes de error como MAX no se puede utilizar con las variables o medidas que creamos.
¡Esperando que alguien pueda ayudarnos!
Solved! Go to Solution.
Pruebe estas medidas:
Total LineHours = SUM ( V_PBI_WO55_DETAILS[LineHours] )
PCT Unplanned DT =
VAR vNumerator =
SUM ( V_PBI_WO55_DETAILS[LineHours] )
VAR vDenominator =
CALCULATE (
SUM ( V_PBI_WO55_DETAILS[LineHours] ),
ALLSELECTED ( V_PBI_WO55_DETAILS )
)
VAR vResult =
DIVIDE ( vNumerator, vDenominator )
RETURN
vResult
Rank LU =
VAR vResult =
RANKX ( ALLSELECTED ( V_PBI_WO55_DETAILS[LineUtilization] ), [Total LineHours] )
RETURN
IF ( HASONEVALUE ( V_PBI_WO55_DETAILS[LineUtilization] ), vResult, BLANK () )
Cumulative Total =
VAR vBaseTable =
ADDCOLUMNS (
ALLSELECTED ( V_PBI_WO55_DETAILS[LineUtilization] ),
"tmpPCT", [PCT Unplanned DT],
"tmpRank", [Rank LU]
)
VAR vRank = [Rank LU]
VAR vResult =
SUMX ( vBaseTable, IF ( [tmpRank] <= vRank, [tmpPCT], 0 ) )
RETURN
IF ( HASONEVALUE ( V_PBI_WO55_DETAILS[LineUtilization] ), vResult, 1 )
Proud to be a Super User!
Pruebe estas medidas:
Total LineHours = SUM ( V_PBI_WO55_DETAILS[LineHours] )
PCT Unplanned DT =
VAR vNumerator =
SUM ( V_PBI_WO55_DETAILS[LineHours] )
VAR vDenominator =
CALCULATE (
SUM ( V_PBI_WO55_DETAILS[LineHours] ),
ALLSELECTED ( V_PBI_WO55_DETAILS )
)
VAR vResult =
DIVIDE ( vNumerator, vDenominator )
RETURN
vResult
Rank LU =
VAR vResult =
RANKX ( ALLSELECTED ( V_PBI_WO55_DETAILS[LineUtilization] ), [Total LineHours] )
RETURN
IF ( HASONEVALUE ( V_PBI_WO55_DETAILS[LineUtilization] ), vResult, BLANK () )
Cumulative Total =
VAR vBaseTable =
ADDCOLUMNS (
ALLSELECTED ( V_PBI_WO55_DETAILS[LineUtilization] ),
"tmpPCT", [PCT Unplanned DT],
"tmpRank", [Rank LU]
)
VAR vRank = [Rank LU]
VAR vResult =
SUMX ( vBaseTable, IF ( [tmpRank] <= vRank, [tmpPCT], 0 ) )
RETURN
IF ( HASONEVALUE ( V_PBI_WO55_DETAILS[LineUtilization] ), vResult, 1 )
Proud to be a Super User!
My friend thank you so much! It appears to have worked perfectly!!! I really appreciate your help. Forgive me for not responding sooner as I was away on vacation. Thank you again!
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 |