cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
prashantseth Frequent Visitor
Frequent Visitor

DAX issue in not return all dimension row

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"

                     )

)

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: DAX issue in not return all dimension row

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.

DAX_issue_in_not_return_all_dimension_row

 

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
prashantseth Frequent Visitor
Frequent Visitor

Re: DAX issue in not return all dimension row

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