sum if

[Milozebre]

Good morning Community, 

I try to make a sum if with column. 

I  have a table with name, days and how many hours the guy work per day. 

Nom	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
Pierre Cardin	7	7	7	7	7	0	0
Jean Reno	0	0	0	0	0	10	10

I want to know 

Pierre : 5 days

Jean : 2 

I read some response here but I cant transpose the solution.

Thanl you in advance

[v-yulgu-msft · Accepted solution]

Hi @Milozebre,

You should unpivot tables first in Query Editor mode.

Then, new a measure as below.

Count working days = CALCULATE(COUNT(Table_1[Weekdays]),Table_1[Value]>0)

Best regards,

Yuliana Gu

[Milozebre]

@v-yulgu-msft

Thank you. 

Its working fine.