Forum Discussion

North_Man's avatar
North_Man
Frequent Visitor
2 years ago
Solved

Any alternative to using Filter for performance

Hi   I am wondering if there is an alternative calc to using below to bring in calculated columns from a dimension table.  It's affecting performance so wonder how we can drop the FIlter. This is...
Need Help
  • North_Man's avatar
    North_Man
    2 years ago

    I will mark this as the solution if anything better comes up will change .Thank you Daniel29195 for your help.

    MANAGER=  VAR TABLE_VAR =      CALCULATETABLE ( VALUES ( DIMENSION_TABLE ), DIMENSION_TABLE[DESCRIPTION] = "MANAGER" )  VAR MAX_VAR =      MAXX (          FILTER (              TABLE_VAR,              FACT_TABLE[DATE_OF_SALE] >= [STARTDATE_]                  && FACT_TABLE[DATE_OF_SALE] <= [ENDDATE_]                  && FACT_TABLE [EMPLOYEEID_] = [EMPLOYEE_ID]          ),          [Value]      )  RETURN      MAX_VAR

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

North_Man 

for the date ,
gor to power query, and change datatype to date for the column,

 

 

North_Man's avatar
North_Man
Frequent Visitor
2 years ago

Maybe I can rephrase disregard my dax ..how would you guys/gals bring in Manager and SM from the dimension table to the fact table satisfying that each sales agent reports to one Manager and one SM at any one time in the most efficient way. Thanks Again