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

Is this possible..?

 

Many Thanks

Mike.

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

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Of the way

     a new measure =

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

     

    Plot with status and mark as % measure

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