Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
3 years ago

Measure doesn't affect visual in Power BI

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.

Need Help

3 Replies

  • Analitika's avatar
    Analitika
    Post Prodigy
    3 years ago

    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's avatar
    Analitika
    Post Prodigy
    3 years ago

    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's avatar
    Anonymous
    Not applicable
    3 years ago

    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.