Getting ready

To prepare for this recipe, perform the following steps:

1. Open Power BI Desktop.
2. Create a new table, R11_Table, using the following formula:

R11_Table = 
    ADDCOLUMNS(
        SELECTCOLUMNS(
            GENERATESERIES(1,1000000),
            "ID",[Value]
        ),
        "Value",100
    )

3. Create the following measures:

Sum 1 = 1000000 * 100

Sum 2 = COUNTROWS('R11_Table') * MAX('R11_Table'[Value])

Sum 3 = SUMX('R11_Table','R11_Table'[Value])

Sum 4 = MAXX(SUMMARIZE('R11_Table','R11_Table'[Value],"__Sum",SUM('R11_Table'[Value])),[__Sum])

Sum 5 = 
    SUMX(
        ADDCOLUMNS(
            SELECTCOLUMNS(
                GENERATESERIES(1,1000000),
                "ID",[Value]
            ),
            "Value",100
        ),
        [Value]
    )

4. Create a Card visualization and place the Sum 1 measure in the Fields area of the visualization.

5. Create a second Card visualization and place the Sum 2 measure in the Fields area of the visualization.
6. Create a third Card visualization and place the Sum 3 measure in the Fields area of the visualization.
7. Create a fourth Card visualization and place the Sum 4 measure in the Fields area of the visualization.
8. Create a fifth Card visualization and place the Sum 5 measure in the Fields area of the visualization.