Forum Discussion

HanishR's avatar
HanishR
Frequent Visitor
6 years ago
Solved

Removing Totals on filtered data

Hi all,  I am trying to remove a total which is showing misleading information,  When the data is filtered, or when it is not, the total columns marked below show the last Month / Quarter Total, ...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi HanishR ,

     

    How about create your Budget measure like so:

    Budget = IF ( [Sales MTD] <> BLANK (), SUM ( 'Sales'[Budget] ) )

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

HanishR , if you have used If in your formula, try to change that to filter.

Or force row context like this

sumx(summarize(Table,Table[class], table[country],"_1",[Budget]),[_1])

 

Please Watch/Like/Share My webinar on Time Intelligence: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
My Your Tube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy

Appreciate your Kudos.

  • HanishR's avatar
    HanishR
    Frequent Visitor
    6 years ago
    I have not used any formulas in this matrix,
    it is purely sum of Budget
    sum of sales
    and then there's measures as needed for % of budget and % Growth.
    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      HanishR , These MTD, QTD, YTD are filter using relative date or some formula ?

      • HanishR's avatar
        HanishR
        Frequent Visitor
        6 years ago
        Yes they are using the built in DAX measures MTD & QTD
        With Base value being sales and date being date table