Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Summarize with distinct values

Hello everyone!   I have a table that i created using summarize: SUMMARIZE('table, 'table'[ID], 'table'[age], 'table'[description])   But there is repeated rows because the "age" For exemple: ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hello @henriquemalone ,

    Create a column as shown below:

    Column = 
var _previousid=CALCULATE(MAX('Table'[ID]),FILTER('Table','Table'[ID]=EARLIER('Table'[ID])&&'Table'[Age]<EARLIER('Table'[Age])))
Return
IF(_previousid=BLANK(),'Table'[Description],BLANK())

    Next, you'll see:

    Screenshot 2020-10-05 162329.png

    For the related .pbix file, see attachment pls.

    Saludos
    Kelly

    Have I answered your question? Mark my position as a solution!

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hello @henriquemalone ,

Create a column as shown below:

Column = 
var _previousid=CALCULATE(MAX('Table'[ID]),FILTER('Table','Table'[ID]=EARLIER('Table'[ID])&&'Table'[Age]<EARLIER('Table'[Age])))
Return
IF(_previousid=BLANK(),'Table'[Description],BLANK())

Next, you'll see:

Screenshot 2020-10-05 162329.png

For the related .pbix file, see attachment pls.

Saludos
Kelly

Have I answered your question? Mark my position as a solution!