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

Sorry, 

 

Once again just trying to understand the use case. 

 

Is this dataset being build for users to create their own report? 

 

Don't understand how the use of the two slicers works for them. 

 

Isn't the purpose of this calculation to be done so that you get the Y or N base on having at least one Y on the c_flag? 

 

Or do you want to see the values also based on the yes or n of the c_flag no matter what is the group for the new measure we did? 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi MFelix ,

yes we use this dataset for both to create static reports and also users to create customized reports.

 

-- Isn't the purpose of this calculation to be done so that you get the Y or N base on having at least one Y on the c_flag? 

  Yes the purpose is same as you mentioned that we get the Y or N base on having at least one
  Y on the c_flag which is achieved by measure or the new table method you suggested.

 

but as I mentioned the users want both flags as slicer

 

If the scenario is not posssible also its ok just making sure if we can achieve it or not so we can convey the users to select the slicers individually.

 

Thank you again for all your help MFelix