Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Im struggling with the following measure. Due to my requirements I know that I have to create a rank after creating a filter. When the rank is created I want to count only the ones. The variables will be dinamyc with a calendar table, but i put it here with a specific date. Can you please help me?
MEASURE 'Tabla de medidas'[prueba] =
VAR FechaHasta = DATE(YEAR(TODAY()), 4, 30)
VAR FechaDesde = DATE(YEAR(TODAY()), 4, 1)
VAR TablaFiltrada =
CALCULATETABLE(
'Asignacion',
(
(
'Asignacion'[fecha_ingreso] <= FechaDesde &&
'Asignacion'[fecha_devuelto] >= FechaDesde
) ||
(
'Asignacion'[fecha_ingreso] >= FechaDesde &&
'Asignacion'[fecha_ingreso] < FechaHasta + 1
)
),
ALLEXCEPT(Asignacion, Asignacion[fecha_ingreso], Asignacion[fecha_devuelto])
)
VAR TablaConRank =
ADDCOLUMNS(
TablaFiltrada,
"Rank",
RANKX (
FILTER (
TablaFiltrada,
[deuda_id] = EARLIER ( [deuda_id] )
),
[dias_atraso] & [documento_id],
,
DESC,
Dense
)
)
RETURN
COUNTROWS((FILTER(TablaConRank, [Rank] = 1)))
Hi @fedeg
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |