Forum Discussion
Post PatronCount Columns that don't contain zero
Post PatronHi,
Data is blank.
Result using your formula returning the same as mine.
Community Champion
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.
- android1
[Visits_NoHrs] is Decimal Number, Format: General
I have the correct invoiced hrs for each week.
Some weeks have blank Invoiced Hrs & some have value. So what I'm trying to do is count the weeks that
have a value ie invoiced hrs not equal to blank.
- vanessafvg
android1 what i am asking you though is [Visits_NoHrs] a measure you created or is it in your base data
maybe something like this would work
calculate (countrows(table), filter (table, sum([Visits_NoHrs]) > 0))
- android1
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)))