cancel
Showing results for
Did you mean:
Anonymous
Not applicable

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'[InProgressDateSK])),0,(count('WorkItems In Progress WIP'[InProgressDateSK])))`

and the blue ones using

`Completed = IF(ISBLANK(count('WorkItems Completed'[CompletedDateSK])),0,(count('WorkItems Completed'[CompletedDateSK])) )`

What i want now is a filter to only hide the values if both Completed AND Started is 0. if one of them is higher then 0 i'd like to show both.

To be honest i have no idea how to do this.

Thankyou.

1 ACCEPTED SOLUTION
Helper II

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

5 REPLIES 5
Helper II

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
Not applicable

@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! 🙂

Frequent Visitor

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
Not applicable
@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.

Resolver III

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.

Announcements

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.