Show percentage of a number of items in a column compared with the total row count of table

[BidyaSingha]

Hello connection,

Below measure display the value of "dept1" only. We can write different measure for other department.
It is possible to write the single measure to get all different department  percentage, Is this achievable?

Below is the "dept1" measure. Instead of writing different measure for different department can we write in single measure?

Measure = 
VAR _A =
    CALCULATE(
        COUNTA( 'Table'[names] ),
        FILTER( ALL( 'Table' ), 'Table'[names] = "dept1" )
    )
VAR _B =
    CALCULATE( COUNTA( 'Table'[names] ), ALL( 'Table' ) )
RETURN
    _A / _B

Thank in advance.

[tamerj1]

Hi @BidyaSingha 
Please try

Measur =
VAR _A =
    COUNTROWS ( 'Table' )
VAR _B =
    CALCULATE ( COUNTROWS ( 'Table' ), ALL ( 'Table'[names] ) )
RETURN
    _A / _B

[sjoerdvn · Accepted solution]

Measure = IF (HASONEVALUE('Table'[names]),
    VAR cur_name = VALUES( 'Table'[names])
    RETURN DIVIDE(
        CALCULATE( COUNTA( 'Table'[names]), ALL( 'Table' ), 'Table'[names] = cur_name )
        ,CALCULATE( COUNTA( 'Table'[names]), ALL( 'Table' ))
    )
)

[Rupak_bi]

try this

Measure = 
VAR _A =
    CALCULATE(
        COUNTA( 'Table'[names] ),
        FILTER( ALLexcept( 'Table' , 'Table'[names] ) )
    )
VAR _B =
    CALCULATE( COUNTA( 'Table'[names] ), ALL( 'Table' ) )
RETURN
    _A / _B