DAX(COUNTROWS)

[Joao_C_Faria]

Good morning,

I have this DAX formula, 

 COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR('Produção'[DataINICIO],'Produção'[DataFIM]),"WORKDAY",if(WEEKDAY([Date],2) >=6,0,1)),[WORKDAY]=1))

but I need to add some Saturdays where the company has open, how I do IT?

Thanks,compliments.

[Joao_C_Faria]

Thanks it helps very much

[PC2790 · Accepted solution]

To identify those saturdays when the company is open, you would need a flag as a separate column and then you can use that in your measure.

Instead of Workday = 1, it would be CompanyOpenDay=1

[Joao_C_Faria]