1 of 1 people found this helpful
Hi Mazhar Sayed,
The basic issue is that there doesn't seem to be any data for those combinations of dimensions you are using, and Tableau doesn't make up data when there isn't any. "No data" is different from Null, and that's why the ISNULL() function is failing.
However, we can tell Tableau to generate a null when there isn't any data, and that's using the following table calculation: LOOKUP(SUM([YourDimension]),0).
This table calc returns SUM([YourDimension]) for the current row, and Null when no value is found. Then you can wrap that in the IIF(ISNULL()) operation to return 0 or a value. alternatively, you could just do the lookup and then Format the calculation to set 0 to be the Text for Special Values.
Let me know if this solved the issue you're experiencing.