i want to reduce this formula forward to simple please help me out

[sajjadsaj]

t3 = var t2 = DIVIDE(sum(Orders[Sales]),CALCULATE(sum(Orders[Sales]),all('date'[day])))

var t1 = DIVIDE(sum(Orders[Sales]),CALCULATE(sum(Orders[Sales]),all('date'[Date (bins)])))

return IF(SELECTEDVALUE('date'[day]),t2,t1)

i want t3 as output

[sajjadsaj]

Hi @amitchandak sir,

both are taking more time then early one i want to reduce according to utilization time. cannot we play with date table ?

[amitchandak]

@sajjadsaj , Try like

t3 =
VAR TotalSales = SUM(Orders[Sales])
VAR SalesByDay = CALCULATE(TotalSales, ALL('date'[day]))
VAR SalesByDateBins = CALCULATE(TotalSales, ALL('date'[Date (bins)]))
RETURN IF(SELECTEDVALUE('date'[day]), DIVIDE(TotalSales, SalesByDay), DIVIDE(TotalSales, SalesByDateBins))

or

t3 =
VAR TotalSales = SUM(Orders[Sales])
VAR SalesByDay = CALCULATE(TotalSales, ALL('date'[day]))
VAR SalesByDateBins = CALCULATE(TotalSales, ALL('date'[Date (bins)]))
RETURN IF(isinscope('date'[day]), DIVIDE(TotalSales, SalesByDay), DIVIDE(TotalSales, SalesByDateBins))