Forum Discussion
Counts for several fields in a single table
You can select all your columns in Power Query editor and under the transform tab hit unpivot columns. This will give you the Attribute and Value columns you're looking for.
You can then create a merged column to get all of your combinations into one column and in Power BI desktop count your merged column.Just a note.. This seems pretty odd, what is your use case? Maybe we can come up with a better solution for you.
You can select all your columns in Power Query editor and under the transform tab hit unpivot columns. This will give you the Attribute and Value columns you're looking for.
You can then create a merged column to get all of your combinations into one column and in Power BI desktop count your merged column.
Just a note.. This seems pretty odd, what is your use case? Maybe we can come up with a better solution for you.
Thank you for the suggestion, Syk, I'll give it a try.
Our use case is the development of several dashboards that will help validate the integrity of data in multiple systems. We have many critical tables that are updated multiple times a year by dozens of employees and it's common for one or more employees to etiher fail to enter important data or to enter incorrect data. Therefore, one of the goals of our validation dashboards will be to pull in every important variable and compare the distribution of dimensions (e.g. how many rental units are in Chicago, how many rental units are available, etc.) to prior data snapshots, in order to get a sense of whether or not the data looks comparable to historical records or whether there are significant deviations. By simply showing the frequency/counts of each dimension in each field, we believe we can get a good sense of the integrity of the data. For instance, if we suddenly see that there are no records for Chicago - or perhaps that every single unit is marked as Available - we can try to track down where the data has gone missing/bad.