Allselected filtering data hierachy

[CarlomV]

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].[Año],

FactInternetSales[DueDate].[Trimestre],

FactInternetSales[DueDate].[Mes],

FactInternetSales[DueDate].[Día]))

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

[Syndicate_Admin · Accepted solution]

@Syndicate_Admin
También debe agregar las columnas [MonthNo] y [QuarterNo]
(Aunque no los veas en el visual se utilizan en la consulta que lo crea para que los meses y trimestres se ordenen correctamente)

[CarlomV]

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

[Syndicate_Admin]

De nada. Con gusto.
¿Podría por favor marcar esto como una solución? 🙂
Gracias