Measure to Filter out Values Based on Current Time

Hi victoryamaykin ,

If I understand correctly, the issue is that you want to filter values based on current time. Please try the following methods and check if they can solve your problem:

1.Create the simple table. 

2.Go to the Modeling tab and click on New measure.

3.Create a measure to filter based on the current time. Enter the following DAX formula.

Measure Numbers = var _date=SELECTEDVALUE(FactTagProduction[DateID])
VAR CurrentHour = HOUR(NOW())
VAR A = YEAR(_date)
VAR B = MONTH(_date)
VAR C = DAY(_date)
VAR D =
CALCULATE(
        SUM(FactTagProduction[ValueStocked]),
        FILTER(
            'FactTagProduction',
        YEAR(TODAY() - 1) = A && MONTH(TODAY() - 1) = B && DAY(TODAY() - 1) = C
    )
)
VAR E =
CALCULATE(
        SUM(FactTagProduction[ValueStocked]),
        FILTER(
            'FactTagProduction',
        YEAR(TODAY()) = A && MONTH(TODAY()) = B && DAY(TODAY()) = C
    )
)
RETURN
IF(
    CurrentHour < 9,
    D,
    E
)

4. Move the measure numbers to the columns.

5.The result is shown below.

If the above ones can’t help you get it working, could you please provide more raw data(exclude sensitive data) with Text format or screenshot to make a deep troubleshooting? It would be helpful to find out the solution.

Looking forward to your reply.

Best Regards,

Wisdom Wu