cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sebasjuniper1 Frequent Visitor
Frequent Visitor

Calculate field compared

Hello

I have this data

Compared.png

 

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Calculate field compared

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Calculate field compared

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sebasjuniper1 Frequent Visitor
Frequent Visitor

Re: Calculate field compared

Thanks  @v-yulgu-msft