Forum Discussion

jussiwaisto's avatar
jussiwaisto
Helper I
6 years ago
Solved

Date slider in sum function? Basic stuff?

Hi, I have this kind of table which includes € column (kauppasumma) and date column (Date) and then I have a date slider where I pick start date and end date.

 

(Date column is related with Date table)

 

I'm calculating ratio and this function works fine:

 

 

But problem is that this function counts all values but doesn't notice my date slider. I would like to count January's ratio but how do I do it?

 

Thank you!

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI jussiwaisto ,

    So you mean you want to use current value to compare with selected values? If this is a case, you can consider using 'allselected' function to replace 'all' function, it will filtered your records based on current filters.

    Ratio =
DIVIDE (
    SUM ( Table[Amount] ),
    CALCULATE ( SUM ( Table[Amount] ), ALLSELECTED ( Table ) )
)

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI jussiwaisto ,

    So you mean you want to use current value to compare with selected values? If this is a case, you can consider using 'allselected' function to replace 'all' function, it will filtered your records based on current filters.

    Ratio =
DIVIDE (
    SUM ( Table[Amount] ),
    CALCULATE ( SUM ( Table[Amount] ), ALLSELECTED ( Table ) )
)

    Regards,

    Xiaoxin Sheng