Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dynamic Column calculation based on Slicer multiple selection

Hi Community,   To explain my request, I take a simple example :   I have a column of data     I use it in a slicer. What I would like, is to generate a measure which will "flag" the sel...
  • Anonymous's avatar
    Anonymous
    8 years ago

    I find a help as a part of the solution in this post by applying the provided formula like this (it is an example) :

     

    After Loss Date = 
    CALCULATE(SUM(CashFlows[CashFlow])*(1-[Loss_Select]),
    FILTER(ALLSELECTED(CashFlows),CONTAINS(ALLSELECTED(DimDeals),DimDeals[Deal_Index],CashFlows[Deal_Index])),
    FILTER(ALL(CashFlows),[Deal_Index]=MAX([Deal_Index])&&CashFlows[Date]>[Date_Loss_Select]))

     

    Contains seems to be help a lot.

     

    The only remained thing is that a slicer can not apply accross reporting

     

    I carry on digging this point.

     

    Regards,

    Ph