%age require a text coulmn

[naseem_1973]

Dear All,

I have a text-based column consisting of different categories of calls in my table. I want to calculate the percentage of each category in this column.

I've tried using distinct count and regular count, but the results are not accurate.

[eliasayyy · Accepted solution]

Cout = COUNTROWS('Table')
Count All = COUNTROWS('ALL('Table')
Count Per = DIVIDE([Count],[Count All])

[Prateek97 · Accepted solution]

Hi @naseem_1973 ,

Hope this works for you.

Measure = COUNT(CTable[Category])/CALCULATE(COUNT(CTable[Category]),ALL(CTable[Category]))

[Prateek97 · Accepted solution]

Hi @naseem_1973 ,

Hope this works for you.

Measure = COUNT(CTable[Category])/CALCULATE(COUNT(CTable[Category]),ALL(CTable[Category]))

[eliasayyy · Accepted solution]

Cout = COUNTROWS('Table')
Count All = COUNTROWS('ALL('Table')
Count Per = DIVIDE([Count],[Count All])

[mlsx4]

Hi @naseem_1973 

Try this:

Total communications = COUNTROWS(MyTable)

% of communications = 

var allValues= CALCULATE([Total communications],ALL(MyTable))
return DIVIDE([Total communications],allValues,0)

If you want to be able to filter and keep being 100%, use this:

% of communications = 

var allValues= CALCULATE([Total communications],ALLSELECTED(MyTable[Communication Method]))
return DIVIDE([Total communications],allValues,0)

[naseem_1973]

Sir , its showin error

[mlsx4]

Hi @naseem_1973 

I don't know why, because for me it's working perfectly. If you select some of the values:

If there's nothing selected:

In fact, my solution also considers the possibility of catching errors while dividing

[naseem_1973]

Please check where I doing mistake.

[mlsx4 · Accepted solution]

Okey, I have just realized why!!!

You are using a var as the name of the function. Var is used to store values (https://learn.microsoft.com/en-us/dax/var-dax).  Take a look at my code, the name is % of communications. I will paste it again:

% of communications = 

var allValues= CALCULATE([Total communications],ALLSELECTED(MyTable[Communication Method]))
return DIVIDE([Total communications],allValues,0)

BTW, variables are really useful in Power BI to improve readability and performance sometimes (https://learn.microsoft.com/en-us/dax/best-practices/dax-variables). 

[naseem_1973]

Thanks,

its working