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,

 

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.