Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

DAX Statement Help - counts within column

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" st...
Need Help
Show and Tell
Tips and Tricks
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi Anonymous,

     

    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])
GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi Anonymous,

 

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])