Calculate days in period ignoring table filters

[Anonymous]

Hi, 

I have a table which I created in Power BI but a measure is not giving me the value I'm expecting. 

I need the measure to essentially do 'Minutes in Period' (from slicer in this scenario is 01/01/2019 - 22/01/2019). So there are 1440 minutes in a day. Times that by 22 days = 31,680 minutes in the period. The field I've put it in is 'DateTimeSLA'. 

My current measure is doing the following;

DateTimeInPeriod =

VAR FirstDay = CALCULATE(MIN('Service Downtime'[Date time reported]),ALLSELECTED('Service Downtime'[Date time reported]))

VAR LastDay = CALCULATE(MAX('Service Downtime'[Date time reported]),ALLSELECTED('Service Downtime'[Date time reported]))

RETURN

CALCULATE(DISTINCTCOUNT('Service Downtime'[Date time reported]),

DATESBETWEEN('Service Downtime'[Date time reported],FirstDay,LastDay))

All I need is the number of minutes between both dates in my slicer, ignoring the table filters/values.

Sample table below;

[v-xicai · Accepted solution]

Hi @Anonymous ,

You can create measure like DAX below.

Total Minute =
VAR FirstDay = CALCULATE(MIN('Service Downtime'[Date time reported]),ALLSELECTED('Service Downtime'[Date time reported]))
VAR LastDay = CALCULATE(MAX('Service Downtime'[Date time reported]),ALLSELECTED('Service Downtime'[Date time reported]))
RETURN
DATEDIFF(FirstDay , LastDay, MINUTE) 

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.