Last answered:

16 Nov 2024

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

15 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

1

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.

Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

10 Nov 2024

2
don't select any filter, it'd heIp
Posted on:

10 Nov 2024

0
i faced the same issue, the reason was I selected by mistake a username in users slicer, try to see if there is a usersname selected uncheck it.
Posted on:

16 Nov 2024

0
also me i have the same issue ,when select currency the card show me blank

Submit an answer