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.
Estoy tratando de calcular el número de filas de una tabla.
Concretamente, este es el resultado que estoy buscando en una visualización para la medida calculada COUNT:
ID_product_table_1 | COUNT(ID_product_table_1) | ID_product_Table2 |
1 | 1 | |
2 | 1 | |
3 | 1 | 3 |
4 | 1 | 4 |
Total | 4 |
Sin embargo, solo funciona el COUNT cuando en la visualización coinciden los ID's de ID_product_table_1 y ID_product_table_2 (en este ejemplo serían los ID's 3 y 4
ID_product_table_1 | COUNT(ID_product_table_1) | ID_product_table2 |
1 | ||
2 | ||
3 | 1 | 3 |
4 | 1 | 4 |
Total | 4 |
El cálculo de count_table_1 que estoy utilizando es simple: COUNT(table1[ID_product_table_1].
No entiendo cuál es le problema alguien puede ayudarme? Muchas gracias
Solved! Go to Solution.
@powerbi2srm , Better to have a common product table joined with both tables and then have count measure from both
@powerbi2srm , Better to have a common product table joined with both tables and then have count measure from both
Thank you! It`s useful to solve my problem but, out of curiosity, is there no other way than creating a new table?
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 |
---|---|
115 | |
101 | |
78 | |
76 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |