Forum Discussion

srlabhe's avatar
srlabhe
Icon for Super User rankSuper User
11 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
    11 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
Icon for Super User rankSuper User
11 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
Icon for Super User rankSuper User
11 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 ?