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

lubosst's avatar
lubosst
Frequent Visitor
7 years ago

Hi,

quick idea:

shown =
IF ( AND ( Started = 0, Completed = 0 ), 0, 1 )

and than on page/visual level filter filter only rows with value 1.

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

Hi,

quick idea:

shown =
IF ( AND ( Started = 0, Completed = 0 ), 0, 1 )

and than on page/visual level filter filter only rows with value 1.

 

Nope, doesnt work.

 

Maybe i have to add that started and completed are measures.