I can't create an aggregation table

Hi Anonymous ,

Please check if this is what you want:

1. Enter another table.

2. Create a measure like so:

Measure = 
SWITCH (
    TRUE (),
    SELECTEDVALUE ( Metric[Metric] ) = "Metric_01", DIVIDE (
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Metric_01] = 1
                    && 'Table'[Date] <= MAX ( 'Table'[Date] )
            )
        ),
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] <= MAX ( 'Table'[Date] ) )
        )
    ),
    SELECTEDVALUE ( Metric[Metric] ) = "Metric_02", DIVIDE (
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Metric_02] = 1
                    && 'Table'[Date] <= MAX ( 'Table'[Date] )
            )
        ),
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] <= MAX ( 'Table'[Date] ) )
        )
    ),
    SELECTEDVALUE ( Metric[Metric] ) = "Metric_03", DIVIDE (
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Metric_03] = 1
                    && 'Table'[Date] <= MAX ( 'Table'[Date] )
            )
        ),
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] <= MAX ( 'Table'[Date] ) )
        )
    ),
    SELECTEDVALUE ( Metric[Metric] ) = "Metric_04", DIVIDE (
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Metric_04] = 1
                    && 'Table'[Date] <= MAX ( 'Table'[Date] )
            )
        ),
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] <= MAX ( 'Table'[Date] ) )
        )
    ),
    SELECTEDVALUE ( Metric[Metric] ) = "Metric_05", DIVIDE (
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Metric_05] = 1
                    && 'Table'[Date] <= MAX ( 'Table'[Date] )
            )
        ),
        CALCULATE (
            COUNTROWS ( 'Table' ),
            FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] <= MAX ( 'Table'[Date] ) )
        )
    )
)

3. Create a line chart.

For more details, please check the attached PBIX file.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.