DAX Measure for % of each type of defect type in Text

[prady2581]

I searched the forum not able to find the solution for below. The dataset has top defects types, I can show each type of defects as count but I want to also show these (each defect type) count of total defect type out of the total defect count. This is text field not able to find a solution for this. 

e.g. in below for Ticket idle % will 3/ 6*100 = 50 % 

Please help

[v-juanli-msft · Accepted solution]

Hi @prady2581

Two methods

1.

2. create a measure

Measure =
DIVIDE (
    CALCULATE (
        COUNT ( Sheet4[ticket] ),
        ALLEXCEPT ( Sheet4, Sheet4[gap reasons] )
    ),
    CALCULATE ( COUNT ( Sheet4[ticket] ), ALL ( Sheet4 ) )
)

Best Regards

Maggie

[petrovnikitamai]

try to add measure

new measure  = divide(count([Gap Reasons]);countx(All([Gap Reasons]);[Gap Reasons])

[Anonymous]

thanks! this a good solution.

One additional problem: how could the expression be written in order to also consider a specific period of time in the dataset?

For example, my dataset is broken down by month and, when I filter in my visualizations by a specific month, the percentages don't change because the expression is considering the full dataset.