Count of the days in the table

[diegolima]

Hello I have a doubt and need help.

I have a table for separate the problems for analice, in this table I have 8 colums:

DATE DEVICE PARAMETER VALIDATION DAY MOUNTH YEAR COUNT

On device column I have the number of equipament for analice, on the parameter column I have a value that indicates the status of device, I need a make a code for that colum validation, I need mark the devices good and bad, butI need to see the validation and count columns, on the column count I try calculate the number of the days that status went good or bad, but I don´t know how making. 

Can someone help me please?

[v-zhenbw-msft · Accepted solution]

Hi @diegolima ,

If you want to check the device is Good or Bad every month, you can refer the following steps,

1. Create two measures to calculate the count of days that the device is good or bad.

Bad Count = CALCULATE(DISTINCTCOUNT('Table'[DATE]),FILTER('Table','Table'[PARAMETER]=7))

Good count = CALCULATE(DISTINCTCOUNT('Table'[DATE]),FILTER('Table','Table'[PARAMETER]=3))

2. Then we need to create a measure to show the status of each month.

Good or Bad = IF([Good count]>[Bad Count],"Good","Bad")

The result like this,

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

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

[diegolima]

This is an example with the false spreadsheet information I have:

DATE	PARAMETER	DEVICE	VALIDATION	DAY	MOUNTH	YEAR	COUNT
Friday, February 21, 2020	7.00	681512 0	DEVICE  BAD	21	February	2020	366
Thursday, February 20, 2020	7.00	681512 0	DEVICE  BAD	20	February	2020	366
Wednesday, February 19, 2020	7.00	681512 0	DEVICE  BAD	19	February	2020	366
Tuesday, February 18, 2020	7.00	681512 0	DEVICE  BAD	18	February	2020	366
Monday, February 17, 2020	7.00	681512 0	DEVICE  BAD	17	February	2020	366
Saturday, February 22, 2020	3	681512 0	DEVICE  GOOD	22	February	2020	366
Sunday, February 23, 2020	3	681512 0	DEVICE  GOOD	23	February	2020	366
Monday, February 24, 2020	3	681512 0	DEVICE  GOOD	24	February	2020	366
Tuesday, February 25, 2020	3	681512 0	DEVICE  GOOD	25	February	2020	366
Wednesday, February 26, 2020	3	681512 0	DEVICE  GOOD	26	February	2020	366
Thursday, February 27, 2020	3	681512 0	DEVICE  GOOD	27	February	2020	366
Friday, February 28, 2020	3	681512 0	DEVICE  GOOD	28	February	2020	366
Saturday, February 29, 2020	3	681512 0	DEVICE  GOOD	29	February	2020	366

In the Validation column to get the result, I need to see the Parameter column (in the example, the value 7.00 is bad and the value 3 is good), but I also need to count the number of days that this value was sent, in the Validation column the final result needs to evaluate the parameter (is it good or bad) and the number of days in the month that this parameter was sent. In this example the validation column is not counting the days, so we have the same device as bad and good in the same month, my goal is to use the number of days to make the device's validation column have only one status or bad or good, in this example the ideal was the device to be as good in the parameters column because during the month of February it sent more parameters good than bad.

I think I explained it a little better, see if you can help me, thank you in advance.

[v-zhenbw-msft]

Hi @diegolima ,

We can create two measures if the validation contain ‘good’ or ‘bad’.

Good day = CALCULATE(DISTINCTCOUNT('Table'[DATE]),FILTER('Table','Table'[VALIDATION]="good"))

Bad day = CALCULATE(DISTINCTCOUNT('Table'[DATE]),FILTER('Table','Table'[VALIDATION]="bad"))

The result like this,

If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data?

It will be helpful if you can show us the exact expected result based on the tables. Please upload your files to OneDrive For Business and share the link here.

Please don't contain any Confidential Information or Real data in your reply.

BTW, pbix as attached.       

Best regards,

Community Support Team _ zhenbw

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

[parry2k]

@diegolima it is a bit hard to understand your problem. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490