DAX Statement Help - counts within column

[irnm8dn]

I am currently using a DAX function to indicate whether particluar row (unit of inventory) is Sold or Available. This is column that is added to the dataset in PowerBI (for each row) using an "if" statement.

I want to further the use the information in this column by doing the following in a  a waffle chart (already downloaded).

1.  How many units are "Available"

2.  How many units are "Sold"

3.  How many total units of Inventory (Available + Sold)

I am trying to arrive at the following as well.

5.  % of units Available (Count of Available divided by Total Inventory)

6.  % of units Sold (Count of Sold divided by Total Inventory)

[GilbertQ · Accepted solution]

Hi @irnm8dn,

If you have got a column which has the actual values 

EG: Column name: Status

• Column Values: Available, Sold

Then what you can do is to create the following Measures

Total Inventory = CountRows('TableName')

Available = CALCULATE([Total Inventory],'TableName'[Status] = "Available")

Sold = CALCULATE([Total Inventory],'TableName'[Status] = "Sold")

% Units Available = DIVIDE([Available],[Total Inventory])

% Units Sold = DIVIDE([Sold],[Total Inventory])

[v-huizhn-msft]

Hi @irnm8dn,

Would your please post same sample data, so we can analysis them directly? If your resource data is confidential, please create same sample data those structure likes your real data.

Best Regards,
Angelia