How to create chart from count itself and show as percentage

[minerallife]

how to create this chart by count "Custom Column" and show it as 2 line (Count itself and show as percentage)
i have date dimention too it's name as "Month&Year"

[v-weiyan1-msft · Accepted solution]

Hi @minerallife ,

Based on your description,
you might consider using the following code to create two Measures.
My Sample:

Sub portion = 
VAR Total = COUNT('Table'[Custom Column])
RETURN 
DIVIDE(COUNTX(FILTER('Table','Table'[Custom Column] = "SUB"),[Custom Column]), Total)

OD portion = 
VAR Total = COUNT('Table'[Custom Column])
RETURN 
DIVIDE(COUNTX(FILTER('Table','Table'[Custom Column] = "OD"),[Custom Column]), Total)

Result is as below.

Is this the result you expect?
For further details, please find attachment.
If I've misunderstood you, please provide detailed sample data and the results you are hoping for. We can better understand the problem and help you. Show it as a screenshot or excel. Please remove any sensitive data in advance.

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@minerallife , Percent of total ?

Two measures

M1 = count(Table[Custom])

M1 % = divide(count(Table[Custom]) , calculate(count(Table[Custom]) , allselected()) )