cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## 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
Community Support

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
Community Support

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

Resolver V

`new measure  = divide(count([Gap Reasons]);countx(All([Gap Reasons]);[Gap Reasons])`
Anonymous
Not applicable

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.