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:
Thanks MFelix for the update.
The data is same with simple date table joined on datekey similar to below
Table1
| P_Code | C_Code | Amt | Datekey |
| 8G1 | 318 | 60 | 20221115 |
| 8G1 | 458 | 30 | 20221115 |
| 8G1 | 314 | 80 | 20221115 |
| G54 | 750 | 40 | 20221115 |
| G54 | 547 | 20 | 20221115 |
| G54 | 458 | 50 | 20221115 |
| TY7 | 159 | 10 | 20221115 |
| 8G1 | 458 | 30 | 20221114 |
| 8G1 | 314 | 80 | 20221114 |
| G54 | 750 | 40 | 20221114 |
| G54 | 547 | 20 | 20221114 |
| G54 | 458 | 50 | 20221114 |
| TY7 | 159 | 10 | 20221114 |
Table2
| C_Code | Flag |
| 318 | Y |
| 458 | N |
| 314 | N |
| 750 | N |
| 547 | N |
| 159 | Y |
Date
| Datekey | Calendar date |
| 20221115 | 11/15/2022 |
| 20221114 | 11/14/2022 |
Relatioship
Similar to column I created a measure as below which is working fine with dates
But again the problem is the C_Flag column selection creates problem
Please see below picture when I select Flag as N the P_Flag_Measure is not worknig fine
C_codes 314 and 458 should show Y but its changing.
In the above image its showing Y and after Flag selection its showing N as below image
Please share you inputs. Thank you
Goed!!