Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Get value based on highest selected period

Hi all,   I'am working on a dashboard to show the development of a fleet. The dashboard consists of mainly three components: 1. A slicer to select the period, 2. A KPI that needs to show the valu...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Something like 

    CALCULATE(sum(table[field]),Filter(table,table[period]=MAX(Kalender[Period])))
     
    Filter(table,table[period]=MAX(Kalender[Period])) == FROM your table you want only the values which have the MAX values in your kalender. When your filter changes the max value will change
     
    From those values you want the sum of a certain field
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Something like 

CALCULATE(sum(table[field]),Filter(table,table[period]=MAX(Kalender[Period])))
 
Filter(table,table[period]=MAX(Kalender[Period])) == FROM your table you want only the values which have the MAX values in your kalender. When your filter changes the max value will change
 
From those values you want the sum of a certain field
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Many thanks Remyo, your solution worked for me!

     

    Thanks for your quick reply!