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:

     

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

You are absolutely right MFelix  everything works fine when individually selected until users are selecting both flags in combination

 

Ex:

Select N from Flag column in Table2 and Y from new Table then we expect to see P_code 8G1 and C_Codes 314 and 458
Select N from Flag column in Table2 and N from new Table then we expect to see P_code G54 and C_Codes 458,547 and 750

I see the measure is changing when we select Flag N from Table2 seems like the measure is considering that particular subset of data and assigning N for
C_Codes 314 and 458

 

 


may be adding allexcept on the 'Table (2)'[Flag] in the "P FLag Measure" might help

sorry however not sure how to add it ðŸ˜Š

MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

Hi Anonymous ,

 

Why are you using the flag from table 2? In this case since you wnat to go over the filter context of the table2 you must not use that column in your slicers/filters or within your visualization because that will break your measures.