Filter out all the zeros in DAX

[ViktorJ]

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?

[ValtteriN · Accepted solution]

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/