Forum Discussion

JDU's avatar
JDU
Helper I
6 years ago

letter count

Dear experts, I can't solve the letter count and then calculate their respective percentages of the total: example: Column 1 a a b c c c I need through DAX to be able to count to get the fol...
MatejZukovic's avatar
MatejZukovic
Resolver I
6 years ago

Hi JDU ,

 

try this to get count:

count = CALCULATE(COUNTA('Table'[Column 1]),ALLEXCEPT('Table','Table'[Column 1]))

and to get %:

% = 'Table'[count] / COUNTROWS('Table')

You can also combine two formulas into 1.

Regards,

Matej

 

 

JDU's avatar
JDU
Helper I
6 years ago

First of all thank you very much for your reply MatejZukovic 

 

The first equation worked very well, the formula responds well, but the second equation does not, it brings me as a result 100% for each of the characters to count.

 

Where do you think the mistake might be?

 

Thanks again!

MatejZukovic wrote:

Hi JDU ,

 

try this to get count:

count = CALCULATE(COUNTA('Table'[Column 1]),ALLEXCEPT('Table','Table'[Column 1]))

and to get %:

% = 'Table'[count] / COUNTROWS('Table')

You can also combine two formulas into 1.

Regards,

Matej

 

 

MatejZukovic wrote:

Hi JDU ,

 

try this to get count:

count = CALCULATE(COUNTA('Table'[Column 1]),ALLEXCEPT('Table','Table'[Column 1]))

and to get %:

% = 'Table'[count] / COUNTROWS('Table')

You can also combine two formulas into 1.

Regards,

Matej

 

 

MatejZukovic wrote:

Hi JDU ,

 

try this to get count:

count = CALCULATE(COUNTA('Table'[Column 1]),ALLEXCEPT('Table','Table'[Column 1]))

and to get %:

% = 'Table'[count] / COUNTROWS('Table')

You can also combine two formulas into 1.

Regards,

Matej

 

 

 

  • MatejZukovic's avatar
    MatejZukovic
    Resolver I
    6 years ago

    Hi JDU ,

     

    previous approach would work when you create column in your backend table.

    If you'd like to do the calculation as a measure, try this:

    % = [count]/CALCULATE(COUNTA('Table'[Column 1]), ALL('Table'[Column 1]))