Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost 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])...
Need 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.