Forum Discussion

_Melenios_'s avatar
_Melenios_
Icon for Helper I rankHelper I
5 years ago
Solved

Data Aggregation - Wrong Total Subtotals

Hi all,   I'm trying to do a data aggregation based on any filter you select( Date,Week,Month etc). My problem is that i cannot get the correct % according to what i choose on the filters.(Eg. If i...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    _Melenios_ 

    i see.  try this then

    Sales perc V2 =
DIVIDE (
    SUM ( Table1[Sales] ),
    CALCULATE ( SUM ( Table1[Sales] ), ALLSELECTED () )
)

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

_Melenios_ 

I think just using a matrix visual (instead of a table visual) and selecting

Show vale as -->Percent of Grand total

for your sales measure  would do the trick (or most of it)?

See it all at work in the attached file.

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

 

_Melenios_'s avatar
_Melenios_
Icon for Helper I rankHelper I
5 years ago

Dear AlB ,

 

Thanks for you reply. Well i have already thought of the solution suggested but my problem here is that i need to have this as measure in order to use this "weighted %" for future calculations as well.

 

For example, if i need to do an estimation for next year sales for any given month i would just need to multiply the weight % that i already know for the given/past year with the SUM of my Expected Sales for that future month.

 

I hope it was clear 🙂