Power Pivot - Looking for a formula that shows the same information that is in the column

[Reports]

Good day,

I hope someone can help me, I am looking for a formula which shows the exact information that is in a column. I am building a pivot table which would show me Kg's sold, for this to work I need to use, Units per crate, Weight per unit and amount of crates sold.

I not problem with the amount of crates sold, but the weight per unit and Unit per crate is where my problem is. I have tried: RELATED, VLAUE, VALUES, DISTINCT and all say that the meassure is returning multiple lines, but the the dax formula is only looking for 1. I need to get the exact weight per crate (I created a calculated column which combines Unit per crate and weight per unit) for my formula to work and give me the correct Kgs sold..

Please assist, I am at a loss..

[amitchandak · Accepted solution]

@Reports , Not create. Seem like you need not summarized information

Add index column and use that in display - not summarized

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi