Forum Discussion
Help with Flag Column
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:
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
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?
Thank you MFelix, for the help