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

Hi _Melenios_ 

Can you share the pbix by any chance?

You'd have to share the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).

 

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