cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
prady2581 Frequent Visitor
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 % 

 

Please help

 

 

% Bar Graph.png

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

Hi @prady2581

Two methods

 

1.

9.png

 

2. create a measure

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

10.png

 

Best Regards

Maggie

 

3 REPLIES 3

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

try to add measure

new measure  = divide(count([Gap Reasons]);countx(All([Gap Reasons]);[Gap Reasons])
Esprami Frequent Visitor
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
Community Support Team

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

Hi @prady2581

Two methods

 

1.

9.png

 

2. create a measure

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

10.png

 

Best Regards

Maggie