Forum Discussion

ShaneOC12's avatar
ShaneOC12
New Member
2 years ago
Solved

PBI Measure Issue

Hi, I have an issue where I'm calculating the Overall Average Monthly Sales, which at the moment is 337 and the total returns (RGA's) per month which varies month to month. I then divide the Total R...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ShaneOC12 

     

    Please try to use the following DAX to create a measure to represent "Overall Average Monthly Sales", I hope it works.

    Overall Average Monthly Sales = 
CALCULATE(
    AVERAGEX(
        VALUES('RGA: Date table'[Month Year]),
        CALCULATE(SUM('RGA: US Sales Data'[Quantity]))
    ),
    REMOVEFILTERS('RGA: Date table'[Month Year])
)

     

    Best Regards,
    Jarvis Tang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ShaneOC12 

 

Please try to use the following DAX to create a measure to represent "Overall Average Monthly Sales", I hope it works.

Overall Average Monthly Sales = 
CALCULATE(
    AVERAGEX(
        VALUES('RGA: Date table'[Month Year]),
        CALCULATE(SUM('RGA: US Sales Data'[Quantity]))
    ),
    REMOVEFILTERS('RGA: Date table'[Month Year])
)

 

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.