measurement or modeling and whichever is best

[jcamilo1985]

good afternoon experts
I have a scenario like the one captured in the images,

I need to express in a graph the number of companies that have no sales.
the table "SalesEnterprise", has all the sales made, the table
assignment has the executive who must make the sale to each company.
However, I cannot obtain the value of those companies to which no product has been sold
can someone advise me to get the result I need.
Thank you

[PaulDBrown · Accepted solution]

@jcamilo1985

First, why is your "intermediate table" hidden? you should use this table in slicers, action filters...

You should also avoid the many-to-many relationship between the two fact tables and create a dimension table with the field being connected instead.

As for your question, do you need a simple count of companies without sales? If so, you can try:
Count of Companies Without Sales =
VAR Companies = VALUES(intermediate table [Id_empresa]
VAR NSales = CALCULATEDTABLE(VALUES(intermediate table [Id_empresa], FILTER(intermediate table [Id_empresa], [Sum of Sales] >0)
Return
COUNTROWS(EXCEPT(Companies, NSales)

[v-deddai1-msft]

Hi @jcamilo1985 ,

Would you please show us more details about your requirements? I am not familiar with the language in your screenshot, so I really can't help you well.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai