Forum Discussion
Independent Column Values for Pivot Table
Hi All,
I have an excel file that has 108 code columns like A6A** and A6K**. I would like to count rows for every single values in excel. However, when I do it with Power BI Pivot Table, it automatically includes some column results to other column. Like below; A6A** column results are under A6K** columns.
Is there any way to do it for independent family results like below?I want to show each column value consecutively for each 108 columns.
Ok. Then... In Power Query M:
let Źródło = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Xc6xCoYwDATgd+nsYlrdU3pm+KekhQzF938NSxX5cQg33MeR3gNc2zyuTjGtYQm8/5hn8shz6UHh5jCyWmQYelC+UcaNxBQmQFO0FLf1o/JUUqoMIJEobjgQ04eVZ+zw0bqaOuhFf2+dFw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Long VIN" = _t, A6K = _t, A6A = _t]), #"Unpivot Other Columns" = Table.UnpivotOtherColumns(Źródło, {"Long VIN"}, "Family", "Value") in #"Unpivot Other Columns"Create New Measure:
Count of VIN = DISTINCTCOUNT('Sample'[Long VIN])
5 Replies
Can you post sample data? I think the issue here is that have 2 columns in your matrix: columnA with value A6KAH and a columnB with value A6AAA. Then using a count of Long VIN you are receiving this combination in matrix. 🙂
So based on this sample data that you have here:
Long VIN A6K A6A EWQTEWQTEASW2341 A6KAA A6AAA QEWRWER2RSDG3412 A6KAB A6ABE QGRQERGEETQET4351 A6KAB A6ABB GDSGTQEG32235EFE34 A6KAB A6ABD QGFWEFEWQRQWE234 A6KAA A6AAA What do you want to count? Based on this 5 rows?