Percentages based off a certain value within my table.

[plushnalmn]

Anyone know how I can do percentages based off a certain value within my table.

Instead of count(sum) I would like to show what’s the %, to test for errors, so the maximum value is the ID, 3,308,371, so I wanna see fill rate of Name, so 65%, and ID would be 100% since we will always have an ID

I’m trying to find the fill rate as a percentage of my ID field
Tried showing as % in table and in matrix but it can only show as a % of the total which isn’t what I want

[ray_ux · Accepted solution]

@plushnalmn 
It's showing total % because it's included blank values, you will need to calculate non blank values, try this calculation:
https://goodly.co.in/calculate-non-blank-values-dax/

Name % =
Dividing(
Calculate(
    Count( [id] ),
    [Name]
),
Count( [id] )
)

[MahyarTF]

Hi,

Not clear to me.

Are the columns (Name, Phone, and Id) in the same table ?

If Yes, Why you don't create a separate Column measure for each column that is calculated the Percentage of value based on ID'd value?

Would you please share some sample data and also your expectation separately?