Calculating Gross Margin Levels filtered by product line and sales amount?

[cdawidow]

Hi guys, I am having trouble calculating gross margin levels based on sale volumes across my various product catagories.  Would if be easier to create a calculated Column or a measure to do this?

I have created a measure such as this but it is coming up blank at times even though I know the sales amount fall within these catagories.

GM% Levels = CALCULATE([Gross Margin %],FILTER(ALLSELECTED(ORDHDT01[PRD PC]),[Total Sales]<=10000))

Table Date =

Net Sales   PRD PC     

$5,000          GMX

$200              HOF

ETC...

[lbendlin]

A measure is the right approach as the result can be impacted by user filter choices. 

But your measure uses other measures, and it is impossible to judge without seeing the code for these.

Your FILTER() is a bit excessive, can probably be rewritten as

GM% Levels = CALCULATE([Gross Margin %],ALLSELECTED(ORDHDT01[PRD PC]),[Total Sales]<=10000)