Allselected filtering data hierachy

[Syndicate_Admin]

Hi everybody,

When trying to delete hierarchy date filtering with ALLSELECTED in a matrix with date(rows) and Countries(columns), first hierarchy level (year) works well but the other (quarter, month, day) don't delete their filter although using multiple columns in ALLSELECTED. How could I solve it? Thanks a lot for your help !!!.

%GrandTotalsinAno = CALCULATE(SUM(FactInternetSales[SalesAmount]),

ALLSELECTED(FactInternetSales[dueDate].[ Year],

FactInternetSales[DueDate]. [Quarter],

FactInternetsales[DueDate]. [My],

FactInternetSales[DueDate]. [Day]))

(Figures not in bold should match the total column ones)

[SpartaBI · Accepted solution]

@Syndicate_Admin 
You need to also add the columns [MonthNo] and [QuarterNo]
(Alltough you don't see them in the visual they are used in the query that creates it in order for the months and quarters to be sorted correctly)

[Syndicate_Admin]

Thanks a lot, I was convinced it should be easy but don't found it. You helped me.

[SpartaBI]

You are welcome. My pleasure.
Could you please mark this as a solution 🙂
Thank you