DAX non-additive measure

[vitro]

Hello, I'm new in DAX and looking for help since I'm out of options...

There's one table with non-additive measure which cannot be calculated and therefore it's provided for every level of product hierarchy separately:

Product Hierarchy	Measure	Value
Product	Share	32
Product-SubProduct	Share	62
Product-SubProduct-Variant	Share	42
Product2	Share	43
Product2-SubProduct2	Share	4
Product2-SubProduct2-Variant1	Share	32

Then there's lookup product table designed as follow:

Product Hierarchy	Product Hierarchy L1	Product Hierarchy L2	Product Hierarchy L3
Product	Product
Product-SubProduct	Product	SubProduct
Product-SubProduct-Variant	Product	SubProduct	Variant
Product2	Product2
Product2-SubProduct2	Product2	SubProduct2
Product2-SubProduct2-Variant1	Product2	SubProduct2	Variant1

I need to create Measure which shows correct value for all levels of product hierachy in pivot table. It means that Product on L1 is showing share as 32, not as sum of SubProducts on L2 etc...

Many thanks for any hint...

[vitro · Accepted solution]

I found the answer, thanks!

[Lidou_Cand]

Hello

Did you found the answer?

I have the same issue in my project.

[LivioLanzo]

@vitro

could you show us your raw table along with expected results?