Dynamic Date measure for custom tooltip when Drilling up or Expanding
I am creating a custom tooltip for a line chart. Users can Drill up or Expand to the next level in the date hierarchy (Year - Quarter - Month). In the tooltip, I'd like to write a measure to display the Year only when viewing on 'year' level, Year and Quarter only when viewing on 'quarter' level , Year and Quarter and Month name on 'month' level. Or any other alternatives. Currently I'm placing textboxes "Year","Quarter","Month" next to respective card visuals (using SELECTEDVALUE()); but a. it's difficult to align them nicely and b. when you're on the 'year' level, the quarter and month cards are blanks, while the texts "Quarter" & "Month" are still there.
Measure with multiple hierarchy levels
Hi, I have some issues on creating a DAX measure with multiple hierarchy level. I have 1 table with unique client code and 4 hierarchy level. Hierarchy 1 contains Hierarchy 2 Hierarchy 2 contains Hierarchy 3 Hierarchy 3 contains Hierarchy 4 Hierarchy 4 contains Client Code I use the relations as descripted in the screenshot. Each hierarchy level is connected to the main hierarchy table. Then each one is connecting to the table with the values. I am using this kind of relation because 'Code Hierarchy' in 'Table' can contain items from Hierarchy 1 or 2 or 3 or 4. When i use drill on a simple graph with the 4 level and a simple measure like Average(Value), i don't get all the data. (i understand why) I have tried some measures with ALL() / ALLSELECTED() / RELATED() / etc ... but it didn't work ... Measure = CALCULATE( AVERAGE(TABLE [Value]); ... ) Could you help me please ? Regards,
