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
Necesita ayuda con la medida y scnario de DAX de la siguiente manera:
From_ID | Conversation_ID | Cid | Concat(From_ID.Conversation_ID) |
San | CON1 | 1 | San_CON1 |
San | CON1 | 2 | San_CON1 |
San | CON1 | 3 | San_CON1 |
mar | CON2 | 1 | Sea_CON2 |
mar | CON3 | 1 | Sea_CON3 |
mar | CON4 | 1 | Sea_CON4 |
sub | CON5 | 1 | Sub_CON5 |
sub | CON6 | 1 | Sub_CON6 |
carnero | CON66 | 1 | Ram_CON66 |
Corrió | CON666 | 1 | Ran_CON666 |
esperado Fuera puesto
Recuento de registros únicos - 3 (recuento distinto de From_ID donde recuento distinto (Concat) = 1)
Recuento de Recrd duplicado - 2 (recuento distinto de From_ID donde recuento distinto (Concat) > 1)
Ayuda con la consulta DAX
Solved! Go to Solution.
@SandhyaVemala , Pruebe medidas como
countx(filter(summarize(Table, table[From_ID], "_1", distinctcount(Table[Concat])), [_1] =1),[From_ID])
countx(filter(summarize(Table, table[From_ID], "_1", distinctcount(Table[Concat])), [_1] >1),[From_ID])
@SandhyaVemala , Pruebe medidas como
countx(filter(summarize(Table, table[From_ID], "_1", distinctcount(Table[Concat])), [_1] =1),[From_ID])
countx(filter(summarize(Table, table[From_ID], "_1", distinctcount(Table[Concat])), [_1] >1),[From_ID])
Muchas gracias Amit la medida funcionó perfectamente y un gran aprendizaje sobre el uso de la función de resumen en COUNTX.
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 |