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(         AL...
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 

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 ?