Blank result in Budget Dashboard due to no transaction for this date in fact table (Sales).

[Pline_69]

Hello Community,

I have built a Calculated table with a daily budget per date, shop, and continent with a CrossJoin of my Calendar table and my budget table (where budgets are monthly). 
When I build my dashboard to display my budget to date per shop per date, I have blank values when there were no transactions in a specific date in my fact (Sales table). 

Any ideas how to avoid that? 
Thanks !

[Pline_69 · Accepted solution]

Hi @v-rzhou-msft ,
I have tried your tips, but it doesn't help. Thanks anyway for the reply.

However, I could find the issue by myself.
My Budget to date formula was missing : "all(_Calendar)"

Dig_BYToToday = CALCULATE(

    SUM('Budget Digital'[Budget Digital 2023]),

    USERELATIONSHIP(DimSales[SalesRepresentative],'Budget Digital'[Sales Representative]),

    all(_Calendar),

    FILTER(all('Budget Digital'[Date]),'Budget Digital'[Date]<=LASTDATE(_Calendar[Date]))

    )

[v-rzhou-msft]

Hi @Pline_69 ,

Please make sure whether you have turn on "Show items with no data" in your field.

On myside, I create a sample to have a test. Data table contains data from 6/25/2023 to 6/30/2023 without 6/26/2023 and 6/29/2023. And it is connect to calendar table.

It won't show blank if I turn off this function.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.