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 

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi _Melenios_,

It sounds like a common total level calculation issue, please take a look at the following blog if it helps your scenario:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

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

Hey Anonymous ,

 

That looks really promissing and i will invest some time for sure! Apreciatted you time!

 

Cheers!