topic Return value in matrix visual only for lowest level of hierarchy in DAX Commands and Tips

Return value in matrix visual only for lowest level of hierarchy

nj-matt — Tue, 30 Mar 2021 17:22:50 GMT

I have a dataset that looks like this -->

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 — Tue, 30 Mar 2021 17:50:33 GMT

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

nj-matt — Wed, 31 Mar 2021 13:20:02 GMT

That did it, thanks!