Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Ignoring filter context in a DAX Measure while using variables

Hi all,   I’m struggling in creating a measure and could use your help:   I need a Measure that first checks, if a framework contract (DIM_Frameworkcontract) is active in a given time period. If...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    invoice amount on contract=sumx(DIM_Frameworkcontract,var _s=DIM_Frameworkcontract[startdate] var _e=DIM_Frameworkcontract[enddate] return calculate(sum(Fact_Invoices[Invoice Amount]),keepfilters(datesbetween(dim_date[date],_s,_e))))

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

invoice amount on contract=sumx(DIM_Frameworkcontract,var _s=DIM_Frameworkcontract[startdate] var _e=DIM_Frameworkcontract[enddate] return calculate(sum(Fact_Invoices[Invoice Amount]),keepfilters(datesbetween(dim_date[date],_s,_e))))