Forum Discussion
Solved
Filtering/counts/if for 0 / Null / and negative value
Really need a helping hand to get an answer in my questions: This is the table, I used a slicer to search their names (dashboard) but what I would like to see are: When I try to search Anna I...
Hi cjb ,
To create a measure as below.
Measure = VAR f1 = CALCULATE ( COUNT ( Table1[Figure 1] ), FILTER ( Table1, 'Table1'[Figure 1] <= 0 || 'Table1'[Figure 1] > 100 ) ) VAR f2 = CALCULATE ( COUNT ( Table1[Figure 2] ), FILTER ( Table1, 'Table1'[Figure 2] <= 0 || 'Table1'[Figure 2] > 100 ) ) VAR f3 = CALCULATE ( COUNT ( Table1[Figure 3] ), FILTER ( Table1, 'Table1'[Figure 3] <= 0 || 'Table1'[Figure 3] > 100 ) ) RETURN f1 + f2 + f3
