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

Icey Thank you for that, and I can see how it helps, but it doesn't remove the total of the Budget Sales MTD when both the sales MTDand budget sales MTD measures are set with the format you mentioned. 

Is there a way to only show the budget sales MTD if there is a Value in the Sales MTD? 


Icey's avatar
Icey
Icon for Community Support rankCommunity Support
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.