Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi Expertos
¿Cómo modificaría la siguiente medida para contar el número de filas (e ignorar Max y maxx) en la medida actual?
_m_get_last_result_count_1 =
// 1st step of 3-sum up counts of last assessed ctrl per org.
//Used in [_m_get_last_result_count_final]
VAR latest_assessed_on =
CALCULATE (
MAXX (
vw_fct_msi_icontrol_task_execution_assessments,
vw_fct_msi_icontrol_task_execution_assessments[assessed_on]
),
FILTER (
vw_fct_msi_icontrol_task_execution_assessments,
NOT ISBLANK ( vw_fct_msi_icontrol_task_execution_assessments[assessed_on] )
&& NOT ISBLANK ( vw_fct_msi_icontrol_task_execution_assessments[result_rating] )
)
)
VAR getRows =
CALCULATE (
COUNTROWS ( vw_fct_msi_icontrol_task_execution_assessments ),
FILTER (
vw_fct_msi_icontrol_task_execution_assessments,
NOT ISBLANK ( vw_fct_msi_icontrol_task_execution_assessments[assessed_on] )
&& NOT ISBLANK ( vw_fct_msi_icontrol_task_execution_assessments[result_rating] )
),
vw_fct_msi_icontrol_task_execution_assessments[assessed_on] = latest_assessed_on
)
VAR get_max =
MAXX ( vw_fct_msi_icontrol_task_execution_assessments, getRows )
RETURN
get_max
No entiendo realmente el contexto, pero aquí hay un intento:
_m_get_last_result_count_1 =
VAR getRows =
CALCULATE (
COUNTROWS ( vw_fct_msi_icontrol_task_execution_assessments ),
FILTER (
ALL(vw_fct_msi_icontrol_task_execution_assessments), // This will reset any filters on your table
NOT ISBLANK ( vw_fct_msi_icontrol_task_execution_assessments[assessed_on] )
&& NOT ISBLANK ( vw_fct_msi_icontrol_task_execution_assessments[result_rating] )
)
)
RETURN
getRows
Supuse que necesitas eliminar todos los filtros. Si es posible, comparta su conjunto de datos y díganos lo que quiere lograr.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.