Vander1981
New Member
- Joined
- Jun 20, 2017
- Messages
- 18
Hi All,
I have got a problem
My data model is the following one : Calendar Table; Product Table; Geography Table; Sales Table.
I created a measure that does the work at the exception of the Grand Total of my Pivot which display a sales extrapolation for each Business area.
DIVIDE ( [Total Sales] ; [Achieved Days] ) * Working Days
What I would like to achieve is that at the Grand total, the measure sums up all the extrapolations at business area level.
I tried every possibility with SUMX but could not solve this.
Thanks a lot for your help.
I have got a problem
My data model is the following one : Calendar Table; Product Table; Geography Table; Sales Table.
I created a measure that does the work at the exception of the Grand Total of my Pivot which display a sales extrapolation for each Business area.
DIVIDE ( [Total Sales] ; [Achieved Days] ) * Working Days
What I would like to achieve is that at the Grand total, the measure sums up all the extrapolations at business area level.
I tried every possibility with SUMX but could not solve this.
Thanks a lot for your help.