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.
Tengo la tabla SurveyData con la columna Comment como se muestra en la tabla. Quiero crear Wordcloud a partir de él.
SurveyKey | Comment |
1 | Buen producto |
2 | Gran paquete |
3 | Falta algo |
4 | Embalaje agradable |
5 | Peor producto |
También hay una tabla Demograph con columna Ubicación:
DemographKey | Location |
1 | Mumbai |
2 | Delhi |
3 | Mumbai |
4 | Mumbai |
5 | Delhi |
Sólo quiero seleccionar aquellos Lugar cuyo encuestado es 3 o más de 3. Al igual que en el caso anterior sólo quiero Mumbai Comentario debe ser utilizado para crear Wordcloud.
¿Hay alguna medida que pueda escribir. No quiero usar la columna como Entrada a WordCloud.
Gracias
Hola
Por favor, pruebe esta medida:
Measure =
IF (
CALCULATE (
COUNT ( Demograph[Location] ),
FILTER (
ALLSELECTED ( Demograph ),
Demograph[Location] IN FILTERS ( Demograph[Location] )
)
) >= 3,
MAX ( Demograph[Location] )
)
El resultado muestra:
Vea mi archivo pbix adjunto.
Saludos
Giotto
@v-gizhi-msft, estoy buscando Filtro de nivel visual en WordCloud. De modo que cada vez que la tasa de encuestados va por debajo de 3. Debería dar algún error.
¿Es posible escribir alguna medida que devuelve la columna comentario sin usar CONCATENAr comentario entero en uno y separarlos por algún delimitador.
Gracias por su tiempo y consideración.
Hola
Pruebe esta columna calculada en la tabla 'SurveyData':
Column =
VAR a =
CALCULATE (
COUNT ( Demograph[Location] ),
ALL ( Demograph ),
FILTER (
Demograph,
Demograph[Location]
= CALCULATE (
MAX ( Demograph[Location] ),
FILTER (
Demograph,
Demograph[DemographKey] = EARLIER ( SurveyData[SurveyKey] )
)
)
)
)
RETURN
IF ( a >= 3, SurveyData[Comment] )
El resultado muestra:
Vea mi archivo pbix adjunto.
Saludos
Giotto
@maqsudcómo estas tablas están conectadas entre sí?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@maqsud claves de clave de encuesta y demográfica son las claves de relación?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@maqsud un poco confundido sobre el modelo, sé que es simple, pero quiere asegurarse de que lo tengo bien, pregunta, es 1 a 1 relación?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 | |
2 | |
2 | |
2 | |
1 |