the page filter doesn't work

[jcamilo1985]

Good night Specialists

I turn to you for help because I've tried to fix it on my own but I can't find a way out and the truth is frustrating.

I have the following data model

I strive to star model following the recommendations of many experts, however now I have difficulty getting the results I need for some data.

in the sales table Company each line represents a sale, in the size directory companies are all companies, some of them have no sale, therefore do not have a related fact in the company sales table

I need to get a graph that tells me by segment (field in the company directory table) and by director how many companies do not have sales, the result is as follows:

as noted I do not get the correct result, in addition in the table of the directory companies make an ABC pareto, nor is it filtering correctly with the page filters

I don't know what else to try, if anyone can help me, I appreciate any guidance before I go crazy.

data model

[amitchandak]

@jcamilo1985 , Try a measure like this

No sales =if(isblank([sales]),1,0)

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.