Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Help Creating Percentages Column

I have an issue where I am trying to create a matrix with a % column of user login per computer, see below.

lordbyronxxiv_0-1647464787480.png

My problem is that I tried to create a measure with this formula

lordbyronxxiv_1-1647464948815.png

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.

4 REPLIES 4
Whitewater100
Solution Sage
Solution Sage

Hello:

Can you try this in your data view? The middle icon on the right side. Then see image below:

Whitewater100_1-1647473608616.png

 

 

Whitewater100_0-1647473556877.png

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!

Anonymous
Not applicable

Unforntunately that will not work, this is what the data in the table looks like

lordbyronxxiv_0-1647522612834.png

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

Anonymous
Not applicable

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

lordbyronxxiv_1-1647533481433.png

link to workbook
https://www.dropbox.com/s/2jtjfwbs4oeo3zl/Asset%20Assignment%20Test.pbix?dl=0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.