Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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
    6 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!

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

Are you creating a dimension table for IDs?

If so, create a new table using VALUES(table[id])
then create a relationship between this dimension table and your fact table by linking the id fields. Use the dimension Id in your visuals. 
However, beware that if you include the age column the id = 1 will be repeated since there are 2 age values for this id. If you want to avoid this, create a measure to find the MAX value for age and use that measure instead of the column in the visual