Mesure Sum the Cut Date from Slicer

[mrbajana]

I need a measure in the table that  sum the sales ​​with the cutoff date, that is, the last date of the segmenter and that in the table I add up and show me only what is in the red box, not the rest , the rest should not appear or show the values os sales ​​at 0. In this case, for example, only the three items that are from July 13, which is the last date selected. Keep in mind that it is a flat table, there are no dates dimensions.

[v-yalanwu-msft · Accepted solution]

Hi, @mrbajana ;

You could create a measure as follows:

Measure =
IF (
    MAX ( [Caiday] ) = CALCULATE ( MAX ( [Caiday] ), ALLSELECTED ( 'Table' ) ),
    CALCULATE (
        SUM ( [Uit veta] ),
        FILTER ( ALLSELECTED ( 'Table' ), [Caiday] = MAX ( [Caiday] ) )))

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.