Skip to main content

Please find the attached workbook.

I have empty rows in the back end and using calculated fields i am not sure how to suppress.

 

Appreciate your help

1 answer
  1. Oct 12, 2023, 8:08 PM

    @krishnapriya Arisetti​ One method is to change which measures you are using. You are creating two measures with based on the year value of [Order Date]. Instead, just use the [Quantity] measure directly and filter the year to 2021 and 2022.

    If you want to create calculations for each year, you can create a filter calculation to test when both years are NULL. Exclude filter TRUE for the calculation

    //F_Measures NULL

    ISNULL([2021 Quantity]) AND ISNULL([2022 Quantity])

     

    James Emery

    Tableau Forums Ambassador

    Please click 'Select as Best' on the one reply that answers your question.