Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Flag data at Certain Threshold

Hello - I am looking for some quick help here to meet a tight deadline.  I am looking to flag certain customers in my data set once their aggregate $ amount hits a certain threshold (in this case $3,...
Need Help
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

parry2k  thank you.  I have adjusted the measure, however it is taking forever to run so I am not sure this solution will work for me if it continues to take this long.

parry2k's avatar
parry2k
Super User
7 years ago

Anonymoustry following changes and see if it performs better

 

Flagged = 
VAR __date = MAX( Table7[Date])
VAR __contractIndex = MAX( Table7[ContractIndex] )
VAR __value = 
CALCULATE( 
SUM( Table7[$ Value] ), 
ALLEXCEPT(Table7, Table7[Customer] ), 
Table7[Date] <= __date, 
Table7[Contract] <= __contractIndex
) 
RETURN IF( __value > 3500, "Y" )
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k  unfortunately no improvement on performance with the updated measure

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous how big is this dataset?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k  30k rows

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous that is nothing, it should really well, not sure what is going on there, were it working fine before we added contract condition for flag, let's try without contract and see if it has good speed.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k  it works without the contract index, but still very slow and does not provide the accurate output I am looking for, 

    I was not even showing an output with the contract index in the measure, it just kept spinning and thinking when I tried to put the measure into a table or graph.