Forum Discussion

sebasjuniper1's avatar
sebasjuniper1
Regular Visitor
7 years ago
Solved

Calculate field compared

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

 

 

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    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