topic Re: Filter out all the zeros in DAX in DAX Commands and Tips

Filter out all the zeros in DAX

ViktorJ — Thu, 26 Jan 2023 09:26:57 GMT

Hi,

I have the following code which gives me the number of hotels pr. hotel-building, meaning the # of hotels always will be 1 (unless there are two hotels in one building, but that's not possible in my case):

SUMX(Hotels,IF([# of hotels]>0,1,0))

The upper code gives me ones and zeros. I only want to include the hotels with an one.

Question: How do I eliminate all the zeros and ONLY include the ones in my DAX?

Re: Filter out all the zeros in DAX

ValtteriN — Thu, 26 Jan 2023 11:08:20 GMT

Hi,

You can place your measure as a filter to your visual. E.g. here my measure (dynamic filter) will return 1 or 0 but I have filtered the visual to only show 1:

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/