Calculate field compared

[sebasjuniper1]

Hello

I have this data

The field items is Sum(Items)

I need to create a new CalcFormula to get the specific vale with the compared Day. In the yello sample 10853 is the item withe te filter Day = DayComapred

Have you got any idea?

Thanks

[v-yulgu-msft · Accepted solution]

Hi @sebasjuniper1 ,

You can create a measure similar to:

Items Compared =
CALCULATE (
    SUM ( Table[Items] ),
    FILTER ( ALL ( Table ), Table[Day] = SELECTEDVALUE ( Table[Day Compared] ) )
)

Best regards,

Yuliana Gu

[sebasjuniper1]

Thanks  @v-yulgu-msft