Calculate Function - Not Working!

[Sougata_Biswas]

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? 

[audreygerred · Accepted solution]

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 · Accepted solution]

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. 

[Sougata_Biswas]

@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.

[audreygerred · Accepted solution]

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).

[Sougata_Biswas]

Thank you so much! Yes, there was an error in the relation. 

[audreygerred]

You're very welcome!