Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

COUNT / PERCENTAGE

Hi, I have a column with 3 different entries in it (Early, Late & On-Time). I'm looking to count the number of entries for each and then have that as a percentage of the total amount of entries (i.e...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    Anonymous 

    Create the following Measure and Replace your Column name:

    Measure1 = 

DIVIDE (
        COUNTA ( 'Product'[Category] ),
        CALCULATE ( COUNTA ( 'Product'[Category] ) , ALLSELECTED('Product'[Category] ) )
    )
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi - Thanks for your prompt reply. Doesnt look like it's liking the proposed DAX.....I need to be able to select a specific column in the table where all the 3 entries are in, which it doesnt seem to want to do. 

Fowmy's avatar
Fowmy
Super User
4 years ago

Anonymous 

Create the following Measure and Replace your Column name:

Measure1 = 

DIVIDE (
        COUNTA ( 'Product'[Category] ),
        CALCULATE ( COUNTA ( 'Product'[Category] ) , ALLSELECTED('Product'[Category] ) )
    )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I am struggling with a similar problem. However the solution is not working fo me. 
    I am considering 'Product' as table name and 'category' as column name. where can i add my value which is on-time/delay?