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.

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
    • HanishR's avatar
      HanishR
      Frequent Visitor
      6 years ago

       

      That is my MTD Sales Formula