How to show only filtered values when creating a measure to show no data

[Anonymous]

Hi 

I am currently running into a very frustrating issue with measures. I have created a measure that allows me to show companies with no data in a certain time period.   SUMX( VALUES( 'Logs Usage (2)'[username] ) ,[Measure 5]) + 0 . However when I apply this it shows all the companies I have filtered out for all pages . Is there a way that I can apply this measure to the filters I have set . Sorry if more infromation is needed please let me know 

[AllisonKennedy]

Why have you added the + 0?

The add zero essentially undoes all your filters, by saying if there is no data, just set this equal to zero. Try deleting the +0 to see if you get closer to expected results, then come back with more info on what Measure 5 DAX is and what you're trying to filter out.

Also see if this might help: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data

[Anonymous]

@AllisonKennedy Thanks for the response . Reason for the + 0 is that I want to see instances of when companies had zero active users , I wont achieve that by using show items with no data .

[AllisonKennedy]

Ok @Anonymous
We'll need much more info then please - why doesn't Show Items with no data work? What is the layout of the visualization you are using?

The +0 will essentially clear all filters as you have discovered, so if you need to keep some filters, you'll have to build that into the measure, so we need to know what filters you are wanting to keep as well that are currently being ignored.

Sometimes I use unrelated tables to solve similar problems to this, but I'm not yet sure if your example falls into that category.

[amitchandak]

@Anonymous , You can use the measure as a filter at a visual level, not at the page level.

If you want to show all companies a measure with +0 in your visual should work

[Anonymous]

@amitchandak thanks for that, the issue when I do that for some reason it shows values that are not even possible to filter out ? For example I will have a company in the visual that will not be evidnet in the filter section ? Sorryf if that is confusing , but it really is driving me crazy

[v-lili6-msft]

hi  @Anonymous 

Sample pbix file and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Lin