Forum Discussion

archerjayden's avatar
archerjayden
Icon for Helper I rankHelper I
5 years ago

DAX Calculation Group Date Filter not working

Hi , I need correction on my dax code as I have tried all possible combinations and I cant figure out the correct version to get my dax automated for calc groups   Working 1 = CALCULATE ( sum(fac...
DAX Calculation
archerjayden's avatar
archerjayden
Icon for Helper I rankHelper I
5 years ago

Sorry this worked 

 

IF (

    ISSELECTEDMEASURE ( [Measure 1] ),
    CALCULATE (
        SELECTEDMEASURE (),
        FILTER (
          ALL(fact_table) ,
            fact_table[scenario] = "ACTUAL" ),
  	FILTER (
          ALL(fact_table) ,
            fact_table[entity] IN VALUES (dim_table[entity])
        ),                     
  		FILTER (
        ALL ( fact_table ),
        fact_table[FiscalYearPeriod]
            >= LEFT(SELECTEDVALUE(dim_date[FiscalYearPeriod]),4) & " P01"
        && fact_table[FiscalYearPeriod] 
            <= SELECTEDVALUE ( 'dim_date'[FiscalYearPeriod] )
  		)
  		))