Forum Discussion

amitnarkar3's avatar
amitnarkar3
Icon for Helper I rankHelper I
9 years ago

ISFILTERED to work with null

HI Team,   I have 3 slicers Level3 --> Level 2 --> Level 1 as hiearchy.   I have done some calculations using following formula.   Calculate = if(ISFILTERED('Hierarchy'[Level1]),CALCULATE(AVERA...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi amitnarkar3,

For your requriement, it's still confusing. Could you please descriobe it in detail based on your given sample data?

Best Regards,
Angelia

amitnarkar3's avatar
amitnarkar3
Icon for Helper I rankHelper I
9 years ago

v-huizhn-msft

Apologies I did not provide enough details earlier. I need to get values from lower nodes in the hierarchy if I have null values in Sublocation.

So if you look at my sample data. There is no sublocation for sydney. The moment I select NULL or Shared(NULL renamed as Shared)
I should get result as blank. If I selewct Washington I should get result as some aggregate function.
Similarly When I select Sydney by default NULL will get selected as parent but in this case instead of blank I need to show some aggregation.