Forum Discussion

AndreasG89's avatar
AndreasG89
New Member
8 years ago
Solved

Creating new measure (Calculating Share)

Hey Guys,   I'm working on a "tricky" case to build a customized measure but at the moment I'm struggeling.   Scenario:   I have a table/list with 3 different failure roots cause (let's assume ...
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    AndreasG89

     

    According to your description, you want to calculate the percentage of all failures for each single failure type. Right?

     

    In this scenario, you just need to use ALLEXCEPT() to have your COUNTROWS() calculation group on each failure type. Please refer to sample below:

     

    Percentage of All = CALCULATE(COUNTROWS(),ALLEXCEPT(Table1,Table1[Failure]))/CALCULATE(COUNTROWS(),ALL(Table1))

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

AndreasG89

 

According to your description, you want to calculate the percentage of all failures for each single failure type. Right?

 

In this scenario, you just need to use ALLEXCEPT() to have your COUNTROWS() calculation group on each failure type. Please refer to sample below:

 

Percentage of All = CALCULATE(COUNTROWS(),ALLEXCEPT(Table1,Table1[Failure]))/CALCULATE(COUNTROWS(),ALL(Table1))

 

Regards,

AndreasG89's avatar
AndreasG89
New Member
8 years ago

Hi v-sihou-msft,

 

this is exactly what I'm was looking for! Excellent!

 

Thank you very much!

 

Best Regards

 

Andreas