COUNT / PERCENTAGE

[Anonymous]

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. 100 entries, 10 are on time, therefore return 10%).

Is this possible..?

Many Thanks

Mike.

[amitchandak]

@Anonymous , Of the way

 a new measure =

divide(countrows(Table), calculate(countrows(Table), allselected(Table))

Plot with status and mark as % measure

[Anonymous]

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 · Accepted solution]

@Anonymous 

Create the following Measure and Replace your Column name:

Measure1 = 

DIVIDE (
        COUNTA ( 'Product'[Category] ),
        CALCULATE ( COUNTA ( 'Product'[Category] ) , ALLSELECTED('Product'[Category] ) )
    )
)

[Anonymous]

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?