Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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..
Solved! Go to 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
@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
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |