Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have an issue where I am trying to create a matrix with a % column of user login per computer, see below.
My problem is that I tried to create a measure with this formula
However I had to change SUM to COUNT because it is a string field. this did not give me the proper output. I tried to create a measure that provided the COUNT or the string field, to give me a numerical output, however the SUM function would not accept that field as a parameter. The output I need is a matrix like above but if a computer has 2 logins each would say 50%. Any help is appreciated.
Hello:
Can you try this in your data view? The middle icon on the right side. Then see image below:
Where it says Data Type and has text now, change it to whole number. I just did this for this example.
Then you should be in business to use your measure.
I hope this works for you!
Unforntunately that will not work, this is what the data in the table looks like
So as you can see, the field I am counting is not a numerical field, it is a list of user names, hence my issue.
You can use COUNT[Table loggins]
or COUNTROWS(TableName)
Those give numerical values.
Please provide file if you'd like to review. Thanks
Here is a sample workbook, as you will see, I tried several different calculated field, they either don't work or do not give the correct output. This is the output I am looking for
link to workbook
https://www.dropbox.com/s/2jtjfwbs4oeo3zl/Asset%20Assignment%20Test.pbix?dl=0
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |