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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors