cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hidenseek9 Member
Member

Facing as issue filtering out data

Hello Power BI Community,

 

I have a problem filtering out data and would love to have your support on it.

 

Here is a problem that I have .

Below is a table that I created.

What this table does is comparing 2017 actual spend (Measure) and 2017 Plan spend (Measure)

and calculate a variance (Measure) by category.

 

What I would like to do in below table, is that

I want to filter out data that has 0 2017 actual spend and 0 plan spend, which has a variance of 0.

So in the end, I would like to have a table with 2017 actual spend or 2017 plan spend >0.

 

I am trying to use filter function, but I am not sure how to do it.

I cannot just filter out "VS Plan" that has a value of 0 because

if actual spend = plan, then I will not be able to see those data.

 

Appreciate your support.

 

Many thanks,

 

H

 

 

Sample photo.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
dilumd Established Member
Established Member

Re: Facing as issue filtering out data

Hi,

 

You can use “IF” function with “AND” function to create a new measure and that can be added to page level filter or report level filter to identify.

 

aa.JPG

 

Variance NIL = IF(AND(Actual Spent=0,Plan Spent=0),"1","0")

2 REPLIES 2
dilumd Established Member
Established Member

Re: Facing as issue filtering out data

Hi,

 

You can use “IF” function with “AND” function to create a new measure and that can be added to page level filter or report level filter to identify.

 

aa.JPG

 

Variance NIL = IF(AND(Actual Spent=0,Plan Spent=0),"1","0")

hidenseek9 Member
Member

Re: Facing as issue filtering out data

@dilumd

 

Thank you so much!

Did not think this could be solved with such an easy measure!!

 

Many thanks,

 

H