Revenue for a dimension without a direct relationship, sales that are not assigned

[GeorgWildmoser]

Hello community,

please give us some support in creating a measure. We categorize our sales by industry in a report. Industry assignment is by customer. This works. 

I need your experience here: Now I want to create a measure that shows me the sales that are not assigned to any industry. The information is related via an intermediate table. How should the measure look like. 

[Shaurya]

Hi @GeorgWildmoser,

This won't be very specific but you can change names based on your table and columns. The following DAX formula should do it:

Other Sales = CALCULATE([Sales], FILTER('Table',ISBLANK('Table'[Industry])))

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Graphical Comparison 

[GeorgWildmoser · Accepted solution]

Thanks for the post. Unfortunately it doesn't work, but your suggested solution reminded me of another post that probably has a similar relation in the data basis. 

Solved: Re: DAX TREATAS and BLANK() - Microsoft Power BI Community

In the end I generated two measures:

Measure1 = CALCULTE(MeasureSalesTotal, TREATAS(VALUES('Industry'[IndustryCategory]),Industry[IndustryCategory]))

Measure2 = MeasureSalesTotal - Measure1

Thanks again.