Forum Discussion
Percentages based off a certain value within my table.
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
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] ) )
2 Replies
- RayWu
Memorable Member
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] ) ) 
MahyarTFHi,
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?