Measure doesn't affect visual in Power BI

[Analitika]

Hi,

I would like to ask how make measure which could filter visual in Power BI. Here my created measure:

Skolu kontrole_pozymis_apyvartumas = 

if(
 (ABS([Pabaigos likutis, eur])<>0 && abs([Pabaigos likutis, vnt.])<>0 ) ||
 (ABS([Pradžios likutis, vnt.])<>0 && ABS([Pradžios likutis, eur])<>0 ) 
  ,  1,0)

I added to filter pane, condition equal 1.

But still it doesn't affect visual in Power BI. So how to resolve this issue? When I applied this filter still see 0 in columns.

[Analitika]

Hi,

I would like to ask how to filter data in Power BI in visual that columns containing 0 will be removed. I tried to use in filter pane, that measure is not 0. But unfortunatelly it didn't filter it and some rows with 0 values remained. So how I could implement this in Power BI? Seems filter not responding to condition.

[Analitika]

Hi,

I would like to ask how I could filter visual that some columns containing 0, rows will be excluded from visual. How I could resolve it?

Visual:

row underlines  should be excluded from visual.

I tried to add condition in filter but it didn't help me:

Measure with conditions in filter pane but it didn't help.

[Anonymous]

Hi @Analitika ,

Here you use ABS() function which will return the absolute value of a number. Your issue is that your measure doesn't filter your visual after you set it to show items when value equal 1 in visual level filter. 

Based on your calculation logic, only if there is 0 in both conditions your measure will return 0, or it will return 1. 

Here I suggest you to try to add four measures into your visual to check whether there are 0 in your measures. I think all measures will return value <>0, then your filter measure will always return 1.

Best Regards,
Rico Zhou

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