Hi, Trying to count the number of weeks which have been invoiced.In attached image, Week numbers are at the top (Wk 3 - 21). The values (14.00, 17.50 etc are the column [Visits_NoHrs]) Trying this fromula -> Num Invoiced Weeks = CALCULATE(COUNTA(vw_PivotVisitsInvoiced[Visits_NoHrs]),vw_PivotVisitsInvoiced[Visits_NoHrs] <> 0) but getting 1 for the example in attached. (expect 8) Regards, Gerry

android1 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?

android1what 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 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 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 isRows > 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.

Forum Discussion

android1

Post Patron

9 years ago

Count Columns that don't contain zero

Hi,

Trying to count the number of weeks which have been invoiced.

In attached image, Week numbers are at the top (Wk 3 - 21).

The values (14.00, 17.50 etc are the column [Visits_NoHrs])

Trying this fromula ->

Num Invoiced Weeks = CALCULATE(COUNTA(vw_PivotVisitsInvoiced[Visits_NoHrs]),vw_PivotVisitsInvoiced[Visits_NoHrs] <> 0) but getting 1 for the example in attached. (expect 8)

Regards,

Gerry

Need Help

12 Replies

vanessafvg
Community Champion
9 years ago
android1

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?
- android1
  Post Patron
  9 years ago
  Hi 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
    Community Champion
    9 years ago
    
    android1
    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?

Forum Discussion

Count Columns that don't contain zero

12 Replies

Related content

Total Count in Column

Counting nulls

Column count duplicates

Count base from other column

Distinctive Count across two columns