Sales last month
I am getting a blank when choosing sales last month. Can someone please help me out
is your dim_Date table connected to the fact_InternetSales table?
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.
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!