Forum Discussion

hansei's avatar
hansei
Helper V
6 years ago
Solved

Help with Summarize

I'm having trouble understanding summarize and wonder if someone could help me? If I have a table as: NAME1 DATE1 NUM1 harry 1/1/2019 11 harry 3/1/2019 22 harry 2/1/2019 33 sa...
DAX
  • hansei's avatar
    hansei
    6 years ago

    I ended up with this for my DAX:

    T2 = SUMMARIZE( 
    Table, Table[NAME1], 
    "DATE2", LASTDATE( Table[DATE1] ), 
    "NUM2", CALCULATE( FIRSTNONBLANK( Table[NUM1], 1 ), LASTDATE( Table[DATE1] ) )
)

    wherein the temporary table returned from LASTDATE propagated filter to orginal Table and then to CALCULATE

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Why don't you simply create measure which finds max date per user and filter out that visual by adding measure into visual level filter.

Max Date =
CALCULATE (
MAX ( Table1[Date] ),
ALLEXCEPT ( Table1, Table1[name] )
)
Filter=if(max(table1[date])= [max date],1,0)

And set this filter measure to 1 in visual level filter.


Thanks
Pravin

If it resolves your problem mark it as a solution.
hansei's avatar
hansei
Helper V
6 years ago

Hellow Anonymous , the measure is needed when the dataset is consumed. My solution cannot be based on visuals.