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

ZunzunUOC's avatar
ZunzunUOC
Resolver III
7 years ago

Do you have activated "Show with no data"?

 

Best Regards,
Miguel

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.