Forum Discussion
Solved
Measure Help
I need a measure to count the number of times each entry from column "UnitID" is in 39 columns labeled Unit2, Unit3,..., Unit40. There are about 800 UnitID's. The UnitID is in the form of A101, ...
Hi,
could you unpivot the columns in power query then group by the attribute which would be the column title to do the count?
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Sorry, I'm not allowed to provide a copy of the file. Other people at my office are looking into the issue now. Thanks for trying to help.