Forum Discussion

Helper III

2 years ago

Solved

DAX logic based on refresh failures or inprogress

Hello, I have a basic 3 column table. However the logic i want to implement i cant quite figure out. Essentially all i want to do is the following: If the [statusname] of a report is either F...

2 years ago

Hi, jakaihammuda

try below

latest status = 
var a = MAXX(all('status'[Load Start Timestamp]),'status'[Load Start Timestamp])
VAR b = MINX(FILTER(ALL('status'),'status'[Entity Name]=MAX('status'[Entity Name]) && 'status'[Load Start Timestamp]=a),
           'status'[Status Name]
        )
var c = MAXX(FILTER(ALL('status'),'status'[Status Name]="succeeded" && 'status'[Entity Name]=MAX('status'[Entity Name])),
          'status'[Load Start Timestamp])
var d = IF(b<>"succeeded",c)
RETURN
d

Dangar332

Resident Rockstar

2 years ago

hi, jakaihammuda

Measure 3 = 
var a = CALCULATE(max('status'[Load Start Timestamp]),ALLEXCEPT('status','status'[Entity Name]))
var b = CALCULATE(MIN('status'[Status Name]),KEEPFILTERS('status'[Load Start Timestamp]=a))
var c = MAXX(
           FILTER( 'status',[Entity Name]=MAX([Entity Name]) && [Status Name]="succeeded"),
           [Load Start Timestamp])
RETURN
SWITCH(TRUE(),
b="failed",c,c)