SelectedValue in hierarchy slicer

[Anonymous]

Hi all,

I've attached a pbix file with more or less the same scenario I'm working on. I have a question related to how to perform different column calculate depending on the selection in the hierarchy slicer.

Here the link of pbix file:

https://t2cspain-my.sharepoint.com/:u:/g/personal/cromero_t2client_com/EbBfGJPqo9lFuBI_WQnTMSMBWQDZF...

I have two measures because i don't know how to do it only in one. 

If you select level 1 in this case "aaaa" as you can see the sum in the measure 2 is correct has be 3. Measure 3 is blak because you didn't select any level 2 so is it correct.

Here we have the first problem, i can't select two different Level 1. is normal because in the measure I'm doing If (selectedvalue but i don't know how to do include OR or a switch.

When you select only one level 2 is working fine, is sum a other columns as it is showed in the measure 3 but i don't understand why the measure 2 is showing the number 1.

And here we have other problem, i can't select more than one level 2 because it shown blank.

Same as before , i can't select different level 2.

I know all this measures are wrong but i don't know how to do it is just to start from something.

I hope you can help me .

Thanks

[amitchandak · Accepted solution]

@Anonymous , refer if this can help https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/