Count Columns that don't contain zero

android1

can you not post a picture of your data in the table?  i.e a screenshot of the actual table (not the results in a visual) of vw_PivotVisitsInvoiced

android1

thanks for the info.  you should be able to slice the data any which way so even with the week num, your measure should work.

i have created a similar scenario and this definitely works.  what are you getting with this?    There is obviously something else going on if the below doesn't work.

I am working on the premise here that 

vw_PivotVisitsInvoiced[Visits_NoHrs] is a decimal

all rows = countrows(vw_PivotVisitsInvoiced)   what do you get back with this?

the measure as previously stated should work when you do this

no of rows  with hours= calculate(countrows(vw_PivotVisitsInvoiced), vw_PivotVisitsInvoiced[Visits_NoHrs] > 0)

if it doesn't there is something else in the data going on?  

eg.

this is the data i created

this works perfectly my measure here is

Rows > 0 = CALCULATE(COUNTROWS(Apartments),Apartments[Hours] > 0)

so i am not understanding why your data is not calculating properly.  You might need to dig a big deeper into the data.  

Sorry, it's a column (not a calculated created by me) It came staright from the Database.

No luck with that either (Num Invoiced Weeks = calculate (countrows(vw_PivotVisitsInvoiced), filter (vw_PivotVisitsInvoiced,  sum([Visits_NoHrs]) > 0)))

Yeah but there are loads of columns in the DB.

Maybe I'll state exactly what 'm trying to do.

New employees start working at any week of the year.

E.g

I have a worker who starts in week 10. They generate [Visits_NoHrs] (column directly from DB) from week 10 onwards.

Say they are off in Week 15 (so no [Visits_NoHrs] generated in Week 15). Back in Wk 16

& work Wk 17, 18, 19 ,20. In Total they have hours in 10 weeks.  I want to count these weeks.

So below I would have 8 as they generated [Visits_NoHrs] in 8 weeks.

I have this calculated column - Week = WEEKNUM([Visits_Date],21) which returns the Week of the year.