Forum Discussion

onedayover's avatar
onedayover
Icon for Helper III rankHelper III
2 years ago
Solved

Replacing blanks with previous count in continuous line chart

Hi All I'm hoping someone will be able to help me modify this measure. I've tried a number of ways to make it work but can't quite seem to get it right. Where there is a blank week (Wk 9 in this exa...
blanks
Help
Line chart
  • aduguid's avatar
    aduguid
    2 years ago
    2024_cate_tickets = 
VAR CurrentCount = COUNTROWS (
    FILTER (
        ALL ( 'cate' ),
        'cate'[week_num] <= MAX ( 'cate'[week_num] )
        && 'cate'[date_registered] <= MAX ( 'cate'[date_registered] )
        && 'cate'[event] = "cate 2024"
    )
)
RETURN
    IF(
        ISBLANK(CurrentCount),
        CALCULATE(
            LASTNONBLANK('cate'[week_num], CurrentCount),
            FILTER(ALL('cate'), 'cate'[week_num] < MAX('cate'[week_num]))
        ),
        CurrentCount
    )
onedayover's avatar
onedayover
Icon for Helper III rankHelper III
2 years ago

Hi aduguid, apologies for the delay in getting back to you. You were correct on both counts - I wasn't using a dimension table and the cate table did not contain wk9 data. I fixed this as you outlined and got the graph to display exactly how I needed it to. Thanks again for your help 🙂