Sales last month
I am getting a blank when choosing sales last month. Can someone please help me out
Can you please show me your DAX?
is your dim_Date table connected to the fact_InternetSales table?
yes, it is connected
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?
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.
I see what the issue is, please select a currency first on your second page, then it should work.
No sir It is still not working, I might have to do all these from scratch
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?
Total Sales Amount = SUM(fact_InternetSales[SalesAmount])
This worked on first page but not on second
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!
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.