Forum Discussion

jakaihammuda's avatar
jakaihammuda
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...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Dangar332's avatar
    Dangar332
    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's avatar
Dangar332
Resident Rockstar
2 years ago

hi, jakaihammuda 

try below measure

 

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

 

 

for latest status

 

latest status = 
CALCULATE(MIN('status'[Status Name]),FILTER('status','status'[Load Start Timestamp]=[Measure 3]))

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.and don't forgot to give kudos.

 

jakaihammuda's avatar
jakaihammuda
Helper III
2 years ago

Hi Dangar332 ,

I got this error when trying to use the "Lates Status" Measure