DAX measure to calculate parent total from child while filtering

[Bacou]

Hi ,

I have two tables:
one with a parent-child hierarchy 

and another containing the data

I created a measure to calculate  the total on each parent : 

Mesure = var c = IF(HASONEVALUE(Hierachie[IdLigne]);VALUES(Hierachie[IdLigne]);BLANK()) RETURN CALCULATE (
sum('Fact'[Amount]);
ALL('Fact');
PATHCONTAINS (Hierachie[HierarchiePath]; c )
)

It works fine but i can't use the slicers (Area and Region) , normal because i use "All" in measure.

What I would like to be able to filter and always show all the codes even if I do not have amount.

For Example i select "Area : A0001" and "Region : R001" i would like to have this result :

Code  |  Amount 

10      | 102

20      |  0

30      |  102

40      |  12048

50      | 0

60      |  12048

70      | 0

80      | 12150

Thank you for your help .

Regards

[Greg_Deckler]

Try ALLSELECTED instead of ALL?

[Bacou]

Hi Greg_Deckler,
thank you for your help i try ALLSELECTED but i don't have all the codes .
Regards

[Greg_Deckler · Accepted solution]

Whoops, my mistake, I didn't read close enough. You can try create a measure along the lines of:

Measure = 
VAR __amount = SUM(Table[Amount])
RETURN
IF(ISBLANK(__amount),0,__amount)

[littlemure]

Hi Greg,

I have the same problem as Bacou, but couldn't understand what your solution means.

I'm studying DAX as beginner, and will be appreciated if you can provide actual code based on Becou's problem. I'll apply it with my case.

Thank you.

Pat.

[Bacou]

Thank you it works.
Regards