Columns - Total without any filter(dynamic) and Total with all filters (dynamic)

[Anonymous]

Hi 

I need an output table which has -
1) Column showing Grand total without any filters applied.
2) Column showing Grand total with filters applied.

The filters are dynamic-
 For Date - there is a slider
 For List of Keywords - there is a checkbox

Thank you in advance.

[amitchandak · Accepted solution]

@Anonymous , You can use removefilters, all, allselected

refer my blog on this

https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak

Or check

https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/