I facing a weired issue, please help me. I am on beginer level so could not solve it.
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.
"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"
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.