Last answered:

07 Jul 2023

Posted on:

12 Nov 2022

0

Sales last month

I am getting a blank when choosing sales last month. imageCan someone please help me out

12 answers ( 0 marked as helpful)
Instructor
Posted on:

12 Nov 2022

0

Can you please show me your DAX?

Posted on:

12 Nov 2022

0

image

Instructor
Posted on:

12 Nov 2022

0

is your dim_Date table connected to the fact_InternetSales table?

Posted on:

12 Nov 2022

0

yes, it is connected image

Instructor
Posted on:

12 Nov 2022

0

ok, is the total sales amount measure returning the correct results? I can see that you have the correct syntax, a relationship and you have also marked your date table as date table. Are the rest of the measures working, i.e. Previous One Month, etc?

Posted on:

12 Nov 2022

0

No sir rest of the measures are also not working. On page 1 they are working fine but on page 2 they are not working.imageimage

Instructor
Posted on:

12 Nov 2022

0

I see what the issue is, please select a currency first on your second page, then it should work.

Posted on:

12 Nov 2022

0

No sir It is still not working, I might have to do all these from scratch image

Instructor
Posted on:

12 Nov 2022

0

It doesn't make sense for the formulas to be working on page one, and not to be working on page two. What does the Total Sales Amount measure look like?

Posted on:

12 Nov 2022

0

Total Sales Amount = SUM(fact_InternetSales[SalesAmount]
This worked on first page but not on second

Posted on:

12 Nov 2022

2

While selecting currency make sure that there is no other filed is selected, check once every filed other than currency and deselect that.
I just hope this will work!

Posted on:

07 Jul 2023

0

I had the same problem on my Page 2 showing blank while Page 1 was fine. It turned out I have selected one username in "Users". Just like what Abdullah Shams said, make sure there is no other filters selected and it should work fine.

Submit an answer