Forum Discussion
Sum the line items based on condition
Hi everyone, I'm trying to write a formula for the conditions below. Someone please help me write a code for the condition. Here for the number of days, I'm want to calculate no of days based...
Try
Total Days = SUMX ( 'Table', IF ( 'Table'[Hours] > 0, 1 ) )
So we should not create measure for such a case?
I wouldn't, no. A measure is typically an aggregation of a value, e.g. the sum or the average. You can't aggregate a country, and typically you would want to use such a thing to slice or filter some measures. Better to have something like that in a column.