DAX formula different requirements

[oskarcph]

Company	Errorcode	Reponsible(Yes/no)
A	1X	Yes
A	2X	Yes
A	3X	Yes
A	4X	No
B	1X	Yes
B	2X	Yes
B	3X	Yes
B	4X	Yes
C	1X	No
C	2X	No
C	3X	Yes
C	4X	Yes

Hi Community 

I am working within the logitics industry where we deal with different clients, every client (Company) has a different contract telling if we are reponsible for a error code or not. See the table as an example. I need to create a KPI for our performance of all total companies, I have tried just to make a dax formula to calcuate the overall perfomance and then put a filter on "Reponsible = Yes" but for it example then it includes errorcode 1x for company A, since 1x is marked yes for company B. 

Hope it makes sense and you can help 🙂 

[v-jianboli-msft]

Hi @oskarcph ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

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

[oskarcph · Accepted solution]

Hi Jianbo  

I solved it by merging multiple tables in query, so this post is not relevant anymore, do you know If I can delete it? 

[v-jianboli-msft]

Hi @oskarcph ,

Since your problem has been solved, you may consider Mark your own reply, so that the post will go to the closed state, other users with similar problems can be inspired by your posting, so that you can better help others.

Best Regards,

Jianbo Li

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

[oskarcph]

Hi @tamerj1 

Sorry for not being specific,  I am looking for ideas/help for have I can make the dax formular to calculate "our" performance on errors. 

Let say we have 100 operations of all three companies (A,B,C) 

we make 10 errors 1x for company A, then our performence is 90%, but if there is a 1x error in the database for company C (which we are not reponsible for) then the calculating formula I have made give the results of 89%

Hope this makes sense 🙂 

[tamerj1]

@oskarcph 

I think it is better to provide the expected results for the given sample of data. 

[tamerj1]

Hi @oskarcph 
Thank you for posting the quetion. Would you please clarify further?