Forum Discussion

oldmanraskers's avatar
oldmanraskers
Frequent Visitor
9 years ago
Solved

Link Calculate Filter and Filter Control

Hello,   Can anyone point me in the direction of how to filter a DAX calculate command based on the value of the the filter control - is that even possible? I am trying to filter a table based on d...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    Hey,

     

    I have to admit that I'm do not understand what you are requesting

     

    If you want to pass the filterselection into your measure calculation try ALLSELECTED

    https://msdn.microsoft.com/en-us/library/gg492186.aspx

     

    If you are looking for something completely different try the search by looking for: dynamic measure

     

    Sorry

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    oldmanraskers

     

    As TomMartens said, you just need to use ALLSELECTED() function on corresponding date column in CALCULATE() function.

     

    Measure=CALCULATE(<expression>, ALLSELECTED(Table[Date]))

     

    Regards,

    Simon Hou

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

I have to admit that I'm do not understand what you are requesting

 

If you want to pass the filterselection into your measure calculation try ALLSELECTED

https://msdn.microsoft.com/en-us/library/gg492186.aspx

 

If you are looking for something completely different try the search by looking for: dynamic measure

 

Sorry

oldmanraskers's avatar
oldmanraskers
Frequent Visitor
9 years ago

Hello Tom,

 

I want the calculate function to filter based on the control below

Thanks.

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    oldmanraskers

     

    As TomMartens said, you just need to use ALLSELECTED() function on corresponding date column in CALCULATE() function.

     

    Measure=CALCULATE(<expression>, ALLSELECTED(Table[Date]))

     

    Regards,

    Simon Hou