Return value in matrix visual only for lowest level of hierarchy

[nj-matt]

I have a dataset that looks like this -->

Category	Brand	SKU	COGS
Candy Bars	Chocolate King	6oz	$      1.50
Candy Bars	Chocolate King	10oz	$      2.00
Candy Bars	Crunchie Bar	8oz	$      1.85
Gum	Chewy Gum	Fruit Flavored	$      0.50
Gum	Chewy Gum	Mint Flavored	$      0.65

When returning the value for Cogs, I only want to display the value for the SKU level.

So in the matrix visual, right now it looks like this (using AVERAGE Dax formula) -->

Instead I only want this -->

Help?

[amitchandak · Accepted solution]

@nj-matt , you can use isinscope and make the value blank when SKU is not in scope

example  measure, where COGS is a measure too

if(not(isinscope(Table[SKU])), blank(), [COGS])

Refer this blog

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

[nj-matt]

That did it, thanks!