How to get the values of the filterd table only

[AShabana]

i need to get the values for the selection of the slicer only (filtered table) while am getting all values even if they are zero but still show in the table !!

[ValtteriN · Accepted solution]

Hi,

Since you are using svg measure the measure is getting values even while the actual values are 0.

You can easily see this if you change your measure's data type.

E.g.

To filter values use a filter measure like this:

Filter for svg =

//replace the SUM with the value you want to be greater than 0

IF(SUM(Demo[Value.1])>0,1,0)

Now place it to your visual like this:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/