cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter on 2 values using AND

Heya Experts!

 

I create the following graph:

graphie.png

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
Sonne
Helper II
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..

View solution in original post

5 REPLIES 5
Sonne
Helper II
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! 🙂

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

ZunzunUOC
Resolver III
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.

Helpful resources

Announcements
Microsoft Build 768x460.png

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_carousel_with_text (1).png

Charticulator Design Challenge

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

May UG Leader Call Carousel 768x460.png

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.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!