Calculate total for an entire month ignoring one field

[Anonymous]

Simple problem: I want to calculate sum of sales for the entire month, but ignore one column that is in the view of a table. This does not seem to be clear or easy, I tried this below thinking this could work. It instead shows the sum of calls for each and every call_queue normally.

Total Calls test 2 =

CALCULATE(

    SUM(TABLE1[CALLS]),

    ALL(TABLE1[CALL_QUEUE])

)

Desired outcome: SUM total across the entire month, that responds to other filters, i.e. region, etc, but does NOT go down to call_queue level. 

So 333,444 for every single row of call_queue.

[Anonymous · Accepted solution]

Hi @Anonymous,

Thanks for the reply from ryan_mayu.

Could you please share a bit more about your data?

Do you want to sum total excluding CALL_QUEUE column in your table?

Please create a measure and write the DAX as below:

Total Calls (Month) = 
CALCULATE(
    SUM('Table'[CALLS]),
    REMOVEFILTERS('Table'[CALL_QUEUE], 'Table'[REGION])
)

Here is the final testing result:

Best Regards,
Qi
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

Thanks, this was a great help!

[ryan_mayu]

could you pls provide some sample data and expected output?