Forum Discussion
Calculate Function - Not Working!
Hi, So I have two tables.
1. Dim Date
2. Fact Table
In the dim date table, I have created a new column that contains week numbers. On the other hand, using the fact table I created a new measure that contains my total revenue.
Now I want to calculate revenue each week.
The formula am using is: "Revenue per Week = CALCULATE([Revenue],All('Dim Date'[Weeknum])"
The result I am getting is:
Can someone tell me what am I doing wrong here?
Hi! For Revenue, just make the measure be Revenue = SUM('Your Table'[Revenue]) then in the visual, put the week numbers in and put in the Revenue measure - it will show you your revenue per week naturally.
Since the figures are repeating that usually indicated that you don't have the date table joined to the fact table. Check to see if you have the join and if it is there, double check that it is working properly (i.e. put date from fact in a table and date from dim date in the same table and see if both columns are filled in).
5 Replies
Hi! For Revenue, just make the measure be Revenue = SUM('Your Table'[Revenue]) then in the visual, put the week numbers in and put in the Revenue measure - it will show you your revenue per week naturally.
audreygerred I tried that too didn't work.
It only works when I create a new column with week numbers in the same table. Not when the week numbers are in another table.
Since the figures are repeating that usually indicated that you don't have the date table joined to the fact table. Check to see if you have the join and if it is there, double check that it is working properly (i.e. put date from fact in a table and date from dim date in the same table and see if both columns are filled in).
