column split by delimiter value lightly different

Hi Anonymous ,

If you want the average after splitting to be equal to the average before splitting, you need to add the index column, and then split the column, like this.

The purpose is to divide the split rows into a group, and only calculate the data of one row when calculating the average value. Using the following formula to calculate the average will get the same result as before splitting the column.

Measure = 
DIVIDE(
    SUMX(
        SUMMARIZE( 'Table', 'Table'[Index], "One_Adjusted", MAX('Table'[Adjusted ]) ),
        [One_Adjusted]
    ),
    DISTINCTCOUNT('Table'[Index])
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

its wokring . i have multiple value column so i want add index column for all  or else i can i use this index for all column .some column values still not matching