Show value in dim table not to have records in fact table

[Anonymous]

Hi everyone,

I have a question regarding value in dim table not to have records in fact table.

In table Category, I have cate C which doesnt have records in table Cost. My question is how to show cate C (with spend = 0) to "visual"

Sorry for my broken English. Hope to hear from you guys soon.

Thank you

[Anonymous]

Thank you so much

[Anonymous]

Hi @rsbin 

Thank you for your response

The output I expected:

cate	spend
A	4
B	2
C	0

Incase C not having any records, I want it to be as zero (0). Could you please advise me on it?

Thank you so much

[rsbin · Accepted solution]

@Anonymous ,

I believe to show a 0 you will have to create a Measure.  Easiest way is:

Cost_Sum = SUM(Cost[Cost]) + 0

Then use this measure in your Visual.

Regards,

[rsbin]

@Anonymous ,

Use Category from your DIM table in your visual.

Then in the column dropdown, select "show items with no data".

Trust this works for you.

Regards,