need to calculate the count-rows of Text column

[Anonymous]

The column is MVT_Source in a table called movement and it is like below, what i need is to ADD Column or measure that counts how many GT rows and another measure for how many Rite rows. Finally a measure that will give me the % of dividing number of GT rows by the total number of rows.

MVT_Source

GT

GT

GT

Rite

Rite

GT

Rite

Rite

GT

[az38 · Accepted solution]

Hi @Anonymous 

try measures

GT rows = CALCULATE(COUNTROWS('TableMovement'), 'TableMovement'[MVT_Source] = "GT" )

Rite rows = CALCULATE(COUNTROWS('TableMovement'), 'TableMovement'[MVT_Source] = "Rite" )

and then

GT rows % = DIVIDE([GT rows], CALCULATE(COUNTROWS('TableMovement')) )

[Anonymous]

Great! worked for me appreciate your great help .