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 ,

 

When you use the values from the column on a slicer or filter you are reducing the data on your model, so if you pick up the NO from table two the 159 will not appear in the values since it's yes.

 

I know you have sent out an example but I still not getting, what is the result you want to get. Has refered when you filter the information from the tables you filter the data, we can skip the filter context however believe that the issue can be at an lower level and the use of the measures and calculated columns is changing that context.

 

If you don't mind can you give (again I know) an example of the results you want to have and how you want the setup of the report?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you  MFelix, for the help