How to calculate the percentage of another column with measures

[Anonymous]

Hi, 

Context: I have a matrix where the first value is a measure returning a count of newly created items. The rest of the values in the matrix are measures that return a count of how many of the newly created items are blank in a specific value e.g. the value named "Code". This will help our data quality employees identify the scope of missing data for newly created items. 

Data: The data is measured and visualized as below: 

• Counting newly created items: count_Items = COUNT(ItemTable1[Item])
• Counting newly created items with "Code" being blank: count_blank_Code = COUNTBLANK(ItemTable1[Code])

Wish: I would like to show the percentage of items being created with "Code" being blank for each row e.g. that the total row is 21,88%.

Question: How do I create a measure for this using the two mesaures I use to get the "New items created" and "Code blank" value?

I apologize in advance if my naming conventions for the measures are horrible. I am very new to Power BI. Any help is much appreciated!

[PabloDeheza · Accepted solution]

Hi @Anonymous !

If I understood correctly, this should solve it:

% of Items =
DIVIDE(
    [New items created],
    [Code blank]
)

Let me know if that helps!