How to get the values of the filterd table only

AShabana — Thu, 04 Jan 2024 09:37:27 GMT

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 !!

Re: How to get the values of the filterd table only

ValtteriN — Thu, 04 Jan 2024 12:52:08 GMT

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/

topic Re: How to get the values of the filterd table only in DAX Commands and Tips

How to get the values of the filterd table only

Re: How to get the values of the filterd table only