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