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.
Team buen dia,
tengo una tabla que tiene las columnas identificacion, Solicitud_ID.
estoy tratando de crear una medida que me traiga la cuenta del DISTINCTCOUNT(BASE_FINAL[IDENTIFICACION]) y que tenga en cuenta toda la tabla BASE_FINAL y adicinal que tenga en cuenta que la solicitud_ID sean iguales las demas filas
intento con esta medida
Solved! Go to Solution.
hi @WilliamForero ,
not sure i fully get you, supposing you have a table like:
try to plot a card visual with a measure like
Measure =
CALCULATE(
DISTINCTCOUNT(BASE_FINAL[IDENTIFICACION]),
REMOVEFILTERS(),
FILTER(
VALUES(BASE_FINAL[SOLICITUD_ID]),
CALCULATE(COUNTROWS(BASE_FINAL))>1
)
)
it worked like:
hi @WilliamForero ,
not sure i fully get you, supposing you have a table like:
try to plot a card visual with a measure like
Measure =
CALCULATE(
DISTINCTCOUNT(BASE_FINAL[IDENTIFICACION]),
REMOVEFILTERS(),
FILTER(
VALUES(BASE_FINAL[SOLICITUD_ID]),
CALCULATE(COUNTROWS(BASE_FINAL))>1
)
)
it worked like:
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |