I have requirement to create two tables one showing all data and one showing data based on certain status value.
I have created second one based on a flag and bring that flag in table and it works fine. but if I click on table column status search bottom I can see all status even the one I have restricted via flag.
If I select those restricted columns then chart shows no data s per expectation.
My question is why it comes in table status column search . It should just show only flag condition one not all
Hi Avneet, Why dont you take a table and create a measure like =If(Flag=1,Status). This way you will be able to see only the required values under status column and since it would be a measure you wont get any search button on this column.