Getting a constant value for Sum DAX Measure

[Anonymous]

Hi Experts

I am trying to work out the Revenue for th month ofAug 20, but the end result is constant number for all my Sales people.

Measure 

Received In Month (£) = CALCULATE(SUM(STG_FACT_Revenue[Total_Acquiring_Revenue_Monthly_Actual]))

See image of model

[FarhanAhmed]

How are you filtering your data for the month of Aug 20?

Are you using Calendar table ?

Do you have relationship defined between your date & the actual data table?

[Anonymous · Accepted solution]

Hi Experts

Apologies the question got deleted accidentally. I have worked out the solution. Many thanks for your patience. 

[v-yingjl]

Hi @Anonymous ,

Glad to hear the issue is solved. You can kindly share your solution and accept your reply as solution, that way, other community members could easily find the answer when they get same issues.

Best Regards,
Yingjie Li

[lkalawski]

Hi @Anonymous
Can you share again your model? Because I can't see the picture.