Aligning dates

[Anonymous]

Hello,

I have a bunch of data by date for a handful of dates from a live SQL. I want to be able to track the different points on a graph with a slicer that chooses the point. A sum by time is a point I want to make. 

I did this to get all the points together and a sum

XDDD1S1N01A = CALCULATE(

    FIRSTNONBLANK(XDDD1S1N01A[DataValue],1),

    FILTER(ALL(XDDD1S1N01A),XDDD1S1N01A[Timestamp]=Dates[Timestamp])

)

The graph is exactly what I want, as is the matrix table, but because of how I did the middle table, the time becomes the slicer, not the point. How can I do this where the point becomes the selected in the slicer, not date and time?

[amitchandak]

@Anonymous , Try like

XDDD1S1N01A = CALCULATE(
FIRSTNONBLANK(XDDD1S1N01A[DataValue],1),
FILTER(ALL(XDDD1S1N01A),XDDD1S1N01A[Timestamp] in values(Dates[Timestamp]) )
)

Or use treatas

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

[Anonymous]

That returned all zeros.