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 ,

 

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

  • MFelix's avatar
    MFelix
    Super User
    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:

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi MFelix ,

       

      Sorry if I confused the main criteria is to use both flags child Flag and

      Parent Flag ( new column or measure created)
      user needs both Flags for slicer selection.

      When we select both Flags to Y its good but when we select N in both Flags we should see only 3 C_codes but we are getting 5 C_codes
      As the criteria is we assign Y to complete parent even one child code has Y in child flag which is in Table2 since 8G1 has one C_code with Child Flag as Y we assign whole parent Flag Y
      When we select both Flags N we expect only G54 to be displayed as it is not having even one c_code with Y in Child Flag

      please see the image below we don't expect the highlighted once when both Flags are set to N.

       

      please suggest if this is fesiable.

       

      Thank you so much for all your help.

       

       

       

      • MFelix's avatar
        MFelix
        Super User
        3 years ago

        Hi Anonymous ,

         

        Clarify me please about the objective of getting the flag slicer, I understood that you want to filter the flag measure by the Y/N meaning that if you select Y the result based on your first image would be:

         

         

         

        His my perception correct? If this is correct then you only need to use the new table has a slicer on the page since the new metric compares the selection of the slicer to the result of the metric.