cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

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

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 %

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: DAX Measure for % of each type of defect type in Text

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

3 REPLIES 3
Member

## Re: DAX Measure for % of each type of defect type in Text

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

## Re: DAX Measure for % of each type of defect type in Text

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.

Community Support Team

## Re: DAX Measure for % of each type of defect type in Text

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