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
Estoy trabajando en un dax , necesario para agregar un filtro dentro de la siguiente dax(highlited en verde)
@harirao, intenta como
Visibilidad - MEDIANX(
RESUMIDA(filtro(Query1[_Wk_Cond2 real]-"Sí"
),Query1[Real _Wk_Cond2],Query1[subregion],Query1[actual_visibility_Weeks],Query1[OpportunityId],"Viswks",
COUNT(Query1[OpportunityId])),
[actual_visibility_Weeks])
Visibilidad - MEDIANX(
RESUMIDO(filtro(Query1,Query1[_Wk_Cond2 actual]-"Sí"
),Query1[Real _Wk_Cond2],Query1[subregion],Query1[actual_visibility_Weeks],Query1[OpportunityId],"Viswks",
COUNT(Query1[OpportunityId])),
[actual_visibility_Weeks])
Falta Query1 en el filtro. Mi error
Prueba esto:
Visibility =
MEDIANX(
SUMMARIZE(
Filter(Query1,Query1[Actual _Wk_Cond2] = "Yes"),
Query1[Actual _Wk_Cond2],
Query1[subregion],
Query1[actual_visibility_Weeks],
Query1[OpportunityId],
"Viswks",
COUNT(Query1[OpportunityId])
),
[actual_visibility_Weeks])
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 | |
1 | |
1 |