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 

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

_Melenios_ , these month , Week values are coming from Calendar table ?

Refer my video for % of total and Sun Total - https://www.youtube.com/watch?v=6jTildcV2ho

 

if that did not help

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.