Forum Discussion

Alta88's avatar
Alta88
Helper IV
2 years ago
Solved

Card Visual - Troubleshoot

My card visual should show total errors from the previous day's accounts but it's returning 'blank':        I've used the following measure for the field value:    Error Count = VAR Cur...
Need Help
  • hackcrr's avatar
    hackcrr
    2 years ago

    Alta88 

    You can use the following adjusted DAX expression:

    Error Count = 
VAR CurrentDate = TODAY()
VAR PrevDay = CurrentDate - 1
VAR DayOfWeek = WEEKDAY(CurrentDate, 2) -- 2 = Monday, 7 = Sunday
VAR SelectedDate = 
    IF(
        DayOfWeek = 1, -- If today is Monday, check for Friday's data
        CurrentDate - 3,
        PrevDay
    )
RETURN 
    CALCULATE(
        COUNTROWS('Table'),
        'Table'[Date] = SelectedDate,
        'Table'[Status] = "Error"
    )

    The results are as follows:

     

     

    Best Regards

    hackcrr

    If I have answered your question, please mark my reply as solution and kudos to this post, thank you!

     

hackcrr's avatar
hackcrr
Memorable Member
2 years ago

Alta88 

You can use the following adjusted DAX expression:

Error Count = 
VAR CurrentDate = TODAY()
VAR PrevDay = CurrentDate - 1
VAR DayOfWeek = WEEKDAY(CurrentDate, 2) -- 2 = Monday, 7 = Sunday
VAR SelectedDate = 
    IF(
        DayOfWeek = 1, -- If today is Monday, check for Friday's data
        CurrentDate - 3,
        PrevDay
    )
RETURN 
    CALCULATE(
        COUNTROWS('Table'),
        'Table'[Date] = SelectedDate,
        'Table'[Status] = "Error"
    )

The results are as follows:

 

 

Best Regards

hackcrr

If I have answered your question, please mark my reply as solution and kudos to this post, thank you!