Forum Discussion

TriveniN's avatar
TriveniN
Icon for Helper II rankHelper II
2 years ago
Solved

Performance Issue

Below measure is taking so much time to load data and some time througing an error Memery out of error Below measure is using  Status is column and that was created by me.   Status = SWITCH(...
  • Greg_Deckler's avatar
    2 years ago

    TriveniN Going to be super difficult to troubleshoot performance-related stuff without access to the PBIX. That said, you might try some or all of the following changes:

    UnitStatus =
    VAR _Table = 
      FILTER(
        SELECTCOLUMNS(
          'vw_Acquired_Property_BRC', 
          "LastModifiedDate",[LastModifiedDate],
          "Table_name",[Table_name],
          "Owner_c",[Owner_c],
          "Status", [Status]
        ),
        [Table_name] = "Competitor"
      )
    Var _LST = MAXX( _Table, [LastModifiedDate] )
    
    VAR _ActiveRecrds = 
      FILTER(
        SELECTCOLUMNS(
          __Table,
          "Owner_c",[Owner_c]
        ),
        [Table_name] = "Competitor" && [LastModifiedDate] >= _LST - 1
      )
    
    VAR _Active = 
      FILTER(
        SELECTCOLUMNS(
          __Table,
          "Status",[Status]
        ),
        [Owner_c] IN _ActiveRecrds 
      )
    
    VAR _ALL = DISTINCT(vw_Acquired_Property_BRC[Status])
                         
    Return
    SWITCH( TRUE(),
            SELECTEDVALUE( ReportType[Type] ) = "Active" , _Active,
            SELECTEDVALUE( ReportType[Type] ) = "All"    , _ALL)