Row Context Flag Issue

[srlabhe]

Hi Team,

I have data which I wanted to filter with below flag as 1 i.e. ToShow=1, formula for ToShow is as below

ToShow =

if(

CALCULATE(

    MAX(Table[AS_OF_DATE]), 

    FILTER(

        ALL(Table),

        Table[Event ID] = SELECTEDVALUE(Table[Event ID]) && 

        Table[AS_OF_DATE] <= [MaxAsOfDateSelected] // Filter for dates before the selected slicer date

    )

)=SELECTEDVALUE(V_EXCEPTION_WF_TASK[AS_OF_DATE]),1,0)

   Now when I apply this filter on Table Visual as ToSHow=1 and have As_Of_Date column in table visual it works fine, but the moment I take the As_Of_Date coplumn from visual the data changes. Like For Event ID 40 as below

with AS_OF_DATE in table visual

 and without AS_OF_DATE its blank like below 

This happens for many Event Ids in report , 40 is just an example. 

Any idea what could be issue here ?

Thanks

[srlabhe · Accepted solution]

This is resolved by creating a column as below

TempCol=[Toshow]

and using this column as well in visual filter as TempCol=1 

[d_m_LNK]

I believe this is blanking the visual because mulitple dates are passed to the visual instead of defining the AS OF Date -  Since it doesn't know what date to limit to it can't complete the calculation and shows blank.

[srlabhe]

There are few other date fields added to visual as part of report requirement, but ToShow has been designed on AS_OF_DATE field only, and not sure hows does it works for other IDs ?