Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Getting a constant value for Sum DAX Measure

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_Rev...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Experts

     

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

FarhanAhmed's avatar
FarhanAhmed
Community Champion
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Experts

     

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

    • v-yingjl's avatar
      v-yingjl
      Community Support
      5 years ago

      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