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...
Need Help
  • 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

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
8 years ago
Anonymous wrote:

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

Anonymous

What do you mean accoss reports? At this moment, the slicer visual in one report page can not interactive with visuals in another page in the same report.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Eric_Zhang,

 

Yes indeed, there are several recent posts about it. I meant that I have to adapt what seems to be a workaround solution (the previous post) for my use case.

 

I hope this feature of "slicers accross pages" combined with "dynamic column" (because it is rather difficult to do this with measure event if I am not very skilled yet) will be considered in the roadmap because it seems to be useful for different business cases.

 

Thank you for your precision.

 

Regards

Ph