locked
DAX query, filter on hierarchy RRS feed

  • Question

  • Hi,

    I have a tabular cube with among a organisation dimension which consist of 6 levels. I have created a query to fetch data from the fact table, date dimension and I want to filter the fact number by organisation unit that is on the 5th level. How can this be achieved.

    My query is like this:

    EVALUATE(
    CALCULATETABLE(
    ADDCOLUMS(
    VALUES('Date'[Day in month']),
    "No hours", 'Hours'[Used hours]
    ),
    'Date'[Year]=YEAR(TODAY())
    ) ORDER BY 'Date'[Day in month'] DESC

    So I would like to add another filter to show only data for used hours and days for a particular organisation unit which is structured like a hierarchy, example of name from level 5 is "Team Sales Unit A".

    Is this possible?

    Monday, November 4, 2013 9:46 AM

Answers

All replies