Forum Discussion

srlabhe's avatar
srlabhe
Super User
10 months ago
Solved

Row Context Flag Issue

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

 
Need Help
  • srlabhe's avatar
    srlabhe
    10 months ago

    This is resolved by creating a column as below

    TempCol=[Toshow]

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

3 Replies

  • d_m_LNK's avatar
    d_m_LNK
    Super User
    10 months ago

    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's avatar
      srlabhe
      Super User
      10 months ago

      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 ?

  • srlabhe's avatar
    srlabhe
    Super User
    10 months ago

    This is resolved by creating a column as below

    TempCol=[Toshow]

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