Data link to keep all category in the table

[irenelitw629]

Hi,

I have 3 data set for sales forecast : This week, Last Week and Forecast category.

I would like to create a table to show all the forecast categoy in one column and this week amount/ Last week amount in other columns. ( if there is no amount in certain category it should appears as $0)

Example:

Forecast Category	This week	Last Week
Closed	$	$
Commit	$	$
Expect	$	$

I appended This week and last week data to a new table. However I am not able to display all the forecast category even after i linked forecast category with appended table.

Attached is the testing file. Can anyone advice me what is the correct steps?

Thanks!

Irene

[Anonymous · Accepted solution]

Hi @irenelitw629 ,

Check the "Show items with no data" feature.

Or you could use IF() function in the measure like

This week = IF(ISBLANK(CALCULATE(SUM('TW ESA'[(USD) NNACV]))),0,1)

Last Week = IF(ISBLANK(SUM('LW ESA'[(USD) NNACV])),0,1)

Best Regards,

Jay

[irenelitw629]

Here is the testing file

https://drive.google.com/file/d/1B_2keLUDGA0mW53ppc8PDszbom1MbAKv/view?usp=sharing