Forum Discussion
Calculating 2 different values from the same table and adding a total collumn
Hello,
I'm still learning about power bi and I while working i got into a problem.
I have a matrix with a list of servers. Whenever I open it, the operative systems that had errors in that specific server will apear.
To make it clear this matrix has 3 parts of data. Servers, Operative Systems and error level.
I can't show the actual table since is not allowed by the company policy but i tried yo recreate one with random values and names just to exemplify. (All the data is attached in the end of the text.)
In this matrix one of my jobs was to create a mesure (that actually one of the Microsoft Power BI super users helped me creating it: [ "Click here to see the conversation" ]) that made only the servers with both errors (level 4 and 5) appear (I called that measure, "filter"). All the others would be hidden. Now I need to add a total collumn to know how many problems that server had, but still, with only the values of the servers with both level of errors.
Also in this total table I should be able to order the rows from the highest to the lowest. This can probably be made either by DAX or with that little arrow that pops in the lower right corner of most of the headers. You are free to use the one that is easier. I know that in the "format" area is possible to add the total table automatically but since both error values (4 and 5) are actually in the same collumn of excel, Power BI cannot understand it to calculate the sum of both values. I'll add the excel and power bi exemples I created and hope someone could help me.
I know it was confuse but I can try to explain better if needed.
Also I'm sorry for my awfullEnglish.
Attachments
Excel table:
The base table:
Openned one whitout the DAX "filter":
With the filter:
The filter itself:
And what i need with the total and without the organization:
(Just in case u didn't got it, this was the litle arrow i was talking about)
And the supost final project should look something like this:
Hope someone understands the problem.
Kind Regards.
6 Replies
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Post the sample data from your first post, but in usable format.
