cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
prashantseth
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
Microsoft
Microsoft

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

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors