DAX ALLEXCEPT ignores Filter Context?

Question

How can I create Quater to date measure through fiscal calendar

QTD =
CALCULATE (
    [Total Amount],
    FILTER (
        ALLEXCEPT ( 'Calendar', 'Calendar'[FiscalYear] ),
        'Calendar'[FiscalQuarter] = MIN ( 'Calendar'[FiscalQuarter] )
            && 'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
    )
)

And this particular formula is not working and how can i resolve this 

Answer 1

Change the code into the following code

CALCULATE(
 [Total Amount],
 FILTER(
   ALL( 'Calendar' ),  
   'Calendar'[FiscalYear] = MIN( 'Calendar'[FiscalYear] )
     && 'Calendar'[FiscalQuarter] = MIN( 'Calendar'[FiscalQuarter] )
     && 'Calendar'[Date] <= MAX( 'Calendar'[Date] )
 )
)

If you want to learn more about Power BI, then read the Power BI Tutorial. Also, enroll in Power BI online Training to become proficient in this BI tool.