Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Help with Flag Column

Hi All,   I have requirement to create a P_Flag column and use in slicer. When any one C_code associated with P_Codes have C_flag as Y then whole P_Flag should be assigned Y. Please find the O/P r...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi,

     

    For this you need to create a disconnected table with the filter to be used in this case Y/N.

     

    The create the following measure:

    Flag_MEasure_filter = IF([P FLag Measure] in DISTINCT('Flag Filter'[Flag filter]), 1)

    Use this measure to filter the table and the column of the disconnected table to use has slicer result below and in attach file:

     

     

     

MFelix's avatar
MFelix
Super User
3 years ago

Hi Anonymous ,

 

Try the following code:

 

Flag = 
VAR P_CodeSelection = Table1[P_Code]
VAR temp_table =
    SUMMARIZE (
        ADDCOLUMNS (
            FILTER ( DISTINCT(Table1[P_Code]), [P_Code] = P_CodeSelection ),
            "FlagValue", RELATED ( Table2[C_Flag] )
        ),
        [FlagValue]
    )
RETURN
    IF (
        CONTAINSSTRING ( CONCATENATEX ( temp_table, [FlagValue] ), "Y" ) = TRUE (),
        "Y",
        "N"
    )

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi MFelix ,

     

    Thank you so much for the reply.

     

    I see the new column is bringing the flag into the Table1 but I would like to add as column is bring new column and assign Y

    even if one C_code has Y then assing Y for the whole P_code as below

     

    I made a code as below which is working fine but not considering when date selected 

     

    Step1: created measure in Table2

    Flag Measure = IF(MAX(Table2[Flag]) = "Y",1,0)

    Step2: created column in Table1

    Flag_new column =
    var __pcode = Table1[P_Code]
    var __max   = maxx(FILTER(ALL(Table1),Table1[P_Code] = __pcode),[Flag Measure])
    return
    IF(__max = 1,"Y","N")
     
    Sorry missed date column date is coming from different table though but the please check below data sample below

     

    P_CodeC_CodeAmtDate
    8G13186011/15/2022
    8G14583011/15/2022
    8G13148011/15/2022
    G547504011/15/2022
    G545472011/15/2022
    G544585011/15/2022
    TY71591011/15/2022
    8G14583011/14/2022
    8G13148011/14/2022
    G547504011/14/2022
    G545472011/14/2022
    G544585011/14/2022
    TY71591011/14/2022

     

    C_CodeFlag
    318Y
    458N
    314N
    750N
    547N
    159Y

     

    Please suggest and help with column if possible to achieve

     

    • MFelix's avatar
      MFelix
      Super User
      3 years ago

      Hi Anonymous ,

       

      I got lost about what is your need.

       

      You want to have a dynamic calculation of the Y/N based on the date selected?

      If that is the case you need a measure and not a column because columns are static calculations, I also need to see how you have the connection with the date values.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Thanks MFelix for the update.

         

        The data is same with simple date table joined on datekey similar to below

        Table1

        P_CodeC_CodeAmtDatekey
        8G13186020221115
        8G14583020221115
        8G13148020221115
        G547504020221115
        G545472020221115
        G544585020221115
        TY71591020221115
        8G14583020221114
        8G13148020221114
        G547504020221114
        G545472020221114
        G544585020221114
        TY71591020221114

         

        Table2

        C_CodeFlag
        318Y
        458N
        314N
        750N
        547N
        159Y

         

        Date

        DatekeyCalendar date
        2022111511/15/2022
        2022111411/14/2022

         

        Relatioship

         

        Similar to column I created a measure as below which is working fine with dates 

         

         

        But again the problem is the C_Flag column selection creates problem 

         

        Please see below picture when I select Flag as N  the P_Flag_Measure is not worknig fine

        C_codes 314 and 458 should show Y but its changing.

        In the above image its showing Y and after Flag selection its showing N as below image

         

         

        Please share you inputs. Thank you