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 ,
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.
Hi Anonymous ,
Clarify me please about the objective of getting the flag slicer, I understood that you want to filter the flag measure by the Y/N meaning that if you select Y the result based on your first image would be:
His my perception correct? If this is correct then you only need to use the new table has a slicer on the page since the new metric compares the selection of the slicer to the result of the metric.
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 750I 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 helpsorry however not sure how to add it 😊
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.
Hi MFelix ,
The reason is users might either select slicer from Table 2 and download the data all child codes affiliated with it or directly select P_flag new colum we created and download data where atleast one child is affiliated.
sometimes they might select combination of slicers.
So the conclusion is we would not be able to do that since we will breaking the measure right?
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?
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