Forum Discussion

gray169's avatar
gray169
Frequent Visitor
4 years ago
Solved

Exclude figures from one Calculation

Hello, I am struggling with a report We have a service desk that receives Incidents (Tickets) with one of three Priorities (Critical, High or Minor) The required report is quite simple, the ...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi, gray169 

    According to your description, You want to ignore the number of "Minor" when calculating [ResponsePct]. Right?

    Here are the steps you can follow：

    (1)This is my test data:

     

    (2)I create a measure like you : “Response Met”

    Response Met = CALCULATE( COUNT(Test[Reponse SLA Met]),FILTER('Test','Test'[Reponse SLA Met]="Met"))+0

     

    (3)We can create a measure : “ReponsePct”

    ResponsePct = DIVIDE( [Response Met] , CALCULATE( COUNT('Test'[Reponse SLA Met]), FILTER( ALL('Test') , 'Test'[Priority] <> "Minor")))

     

    (4)We can put the measure and other fields in the visual , then we can meet your need :

    If this method does not meet your needs, can you provide your input and output sample data in tabular form? So that we can better help you solve the problem.

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi, gray169 

According to your description, You want to ignore the number of "Minor" when calculating [ResponsePct]. Right?

Here are the steps you can follow：

(1)This is my test data:

 

(2)I create a measure like you : “Response Met”

Response Met = CALCULATE( COUNT(Test[Reponse SLA Met]),FILTER('Test','Test'[Reponse SLA Met]="Met"))+0

 

(3)We can create a measure : “ReponsePct”

ResponsePct = DIVIDE( [Response Met] , CALCULATE( COUNT('Test'[Reponse SLA Met]), FILTER( ALL('Test') , 'Test'[Priority] <> "Minor")))

 

(4)We can put the measure and other fields in the visual , then we can meet your need :

If this method does not meet your needs, can you provide your input and output sample data in tabular form? So that we can better help you solve the problem.

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly