Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Syndicate_Admin
Administrator
Administrator

Modificar la medida para contar filas NO basadas en MAX y MAXX

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
1 REPLY 1
Syndicate_Admin
Administrator
Administrator

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.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.