Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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, A102... through Z101, Z102... The 39 columns have the number of times the UnitId was Unit2...Unit40.
I'm new to Power BI and I keep getting errors or obviously bad numbers with my formulas. Below is a snip of the data.
Thanks for any help,
Ronnie
Solved! Go to Solution.
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.
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 👍
I had to include another column with the unpivot and it worked.
Thank you.
Do you have a copy of the PBIX file or the data i could look at?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
77 | |
61 | |
47 | |
17 | |
12 |