Ignore all filters in measure (excluding selected date range)

[Anonymous]

Hi,

I've searched everywhere for a solution to this but not having any luck.

I'm trying to write a calculate formula to create a kind of 'Grand Total' on every row for a given date range (ignoring all other filter context).

Effectively, something that says:

Grand Total Orders for Selected Date Range = Calculate(PerformanceTable[Total Orders],ALL(PerformanceTable),***FILTERED BY SELECTED DATE RANGE***)

Please can you help me with this?

Many thanks!


Dom
 

[amitchandak · Accepted solution]

@Anonymous ,

Try like

Grand Total Orders for Selected Date Range = 
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return 
Calculate(PerformanceTable[Total Orders],filter(ALL(PerformanceTable),PerformanceTable[Date]>=_min && PerformanceTable[Date]<=_max))

[Anonymous]

You can use SELECTEDVALUE to get the value from your dateslicer and use it in a FILTER expression. 

[Anonymous]

Hi @Anonymous ,

Please can you expand on how I would do this?  Sorry, I'm fairly new to Power BI.  🙂

[Anonymous]

@Anonymous 

If you could share a sample dataset of your report i could write the measure for you and explain how it works 🙂