Forum Discussion

rawmeat's avatar
rawmeat
Frequent Visitor
8 years ago

Optimize Summarize dax expression

Hello developers,   Our team recently create a measure to get latest value. The dax expression we are using is as follows: Latest Error = SUMX ( SELECTCOLUMNS ( SUMMARIZE ( ...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
8 years ago

Hi rawmeat,

Based on my test, I could ues the max function to get the value.

Are there any other restrictions? If I misunderstand you, please let me know as soon as possible.

 

Regards,

Daniel He

  • rawmeat's avatar
    rawmeat
    Frequent Visitor
    8 years ago

    Thanks for the reply!

    Sorry let me explain in detail
    Let's say we have the following table in our datasource.

    CELL     FLOW    USER    TIMESTAMP       ERROR

    A                      A                      1                                  1                      100

    A                      A                      1                                  2                      125

    A                      A                      2                                  3                      150

    B                      A                      1                                  4                      200

    B                      B                      1                                  5                      250

    B                      B                      2                                  6                      300

    In our reports the table structure is as follows and we apply "User" as a filter
    CELL FLOW ERROR

    Our user wants to know the latest error in the current context.
    If we select USER 1, we should see
    CELL     FLOW    USER    TIMESTAMP       ERROR

    A                      A                      1                                  2                      125

    B                      A                      1                                  4                      200


    If we select USER 2,
    CELL     FLOW    USER    TIMESTAMP       ERROR

    A                      A                      2                                  3                      150

    B                      B                      2                                  6                      300


    If we select all user, we should see
    CELL     FLOW    USER    TIMESTAMP       ERROR

    A                      A                      2                                  3                      150

    B                      A                      1                                  4                      200

    B                      B                      2                                  6                      300

     

    So in the report the user will see the following results:
    CELL               FLOW             ERROR

    A                      A                      150

    B                      A                      200

    B                      B                      300