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_Revenue[Total_Acquiring_Revenue_Monthly_Actual]))
 
See image of model
 
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. 

4 Replies

  • lkalawski's avatar
    lkalawski
    Icon for Resident Rockstar rankResident Rockstar
    5 years ago
    Hi Anonymous
    Can you share again your model? Because I can't see the picture.
  • FarhanAhmed's avatar
    FarhanAhmed
    Icon for Community Champion rankCommunity 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
        Icon for Community Support rankCommunity 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