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