Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter on 2 values using AND

Heya Experts!   I create the following graph: As you can see there is alot of 0 0 values.   The orange bar is calculated using  Started = IF(ISBLANK(count('WorkItems In Progress WIP'[InPr...
Need Help
  • Sonne's avatar
    Sonne
    7 years ago

    Hi,

     

    i would try to create a new measure:

     

    Sum=started+completed

     

    and put this messure into the filter area and set the filter for "SUM" is greater than 0 ....

    but maybe there is a better solution..

Sonne's avatar
Sonne
Helper II
7 years ago

Hi,

 

i would try to create a new measure:

 

Sum=started+completed

 

and put this messure into the filter area and set the filter for "SUM" is greater than 0 ....

but maybe there is a better solution..

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Sonne wrote:

Hi,

 

i would try to create a new measure:

 

Sum=started+completed

 

and put this messure into the filter area and set the filter for "SUM" is greater than 0 ....

but maybe there is a better solution..

Sometimes i wonder how i cant come up with this kind of stuff..

 

Thanks alot! :)