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 réponse
@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.