DAX issue in not return all dimension row

[prashantseth]

Hi Everyone,

I facing a weired issue, please help me. I am on beginer level so could not solve it.

Problem

There is 2 dimension ( Date and Store) and one fact table ( Daily Sales). Fact table has WTD and DialyNet Sales measures defined in tabular model.

In Excel (Working) à

When we drag stores in row and DailySales in values for a specific date, one store(5618- Fort St) is missing because there is no data for missing store in fact table due to some connectivity issue. (Working as expected)

When we drag stores in row and WTD Sales in values for a specific date, one store start appearing(5618- Fort St) because there is data for week but missing for selected date(due to connectivity) (Working as expected)

In DAX (Not working)

We run DAX query to run for a day when DailySale is missing, Store is not appearing even though I am using WTD sale.

Query

evaluate(

                     calculatetable (

                                                Addcolumns(

                                                summarize(

                                                DailyStoreSales,

                                                Store[areaid],

                                                Store[Area Name],

                                                Store[Store Number],

                                                Store[Store Name],

                                                Store[BrandID],

                                                Store[isFranchise],

                                                'Date'[DateKey]

                                                ),

                                             "Net_WTD_SalesTY",Calculate(DailyStoreSales[WTD Net Sales])

                                                ),

                     'Date'[DateKey] = 20180212,

                     Store[BrandID] = 52651,

                     Store[Area Name] = "KFC Area 3"

                     //,Store[Store Name] = "5618 - Fort St"

                     )

)

[v-jiascu-msft]

Hi @prashantseth,

Why using a DAX formula like that? You can import data into Power BI Desktop by "Get Data". Then you can drag the columns into the fields as you do in the Excel.

If you want a more specific solution, please provide a dummy sample.

Best Regards,

Dale

[prashantseth]

I found fix, I was considering Fact table in Summerize section thats why WTD was not showing result. Thanks for reply