Calculated measure help - need total average across total of all itemIDs

[robdhondt]

Hi @Eleri -

This post shows how to use rank like you would row_number to remove duplicates.

SumOver -Summing distinct entries from a table with duplicate rows

Hi @Ummehaani - Here is an alt. solution, if you don’t have any true duplicate rows in your dataset but rather duplicate values (Customer Name). You can approach this in the analysis without data prep/ETL. Note: You want to weigh the cost of the window functions if you are working with a large dataset (rows and columns). You can also generate row number in your ETL (for this example I kept everything at the analysis level) [image]