Forum Discussion
Post PatronCount Columns that don't contain zero
Community Champion
wouldn't > 0 work better then <> 0? i am assuming its a number?
your example doesn't make sense to me, what should be 1 or shouldn't be?
Post PatronHi vanessafvg,
>0 returns the same. Num Invoiced weeks should be 8 as there are 8 times (weeks) where [Visits_NoHrs] is not zero.
I want to count the weeks where [Visits_NoHrs] <> 0.
I get 1 rather than 8.
- vanessafvg
what does your data look like? can you post a screenshot?
what if you tried something liek this
Num Invoiced Weeks = CALCULATE(countrows(vw_PivotVisitsInvoiced), not(isblank(vw_PivotVisitsInvoiced[Visits_NoHrs]))
is the data blank or 0?
- android1
Hi,
Data is blank.
Result using your formula returning the same as mine.
- vanessafvg
what is your data type on no of hours? is the row you posted below an example of what your date looks like in the tables at a detailed level?
what about, noofrows = calculate(countrows(vw_PivotVisitsInvoiced), vw_PivotVisitsInvoiced[Visits_NoHrs] > 0)
you need to provide more information otherrwise it will be very difficult to provide you with help based on the information you have given. It seems to me either the data type is not as expecvted or i am nto seeing the actually data as it is in the table. as a detail level.