Dynamic Column Selection With Mandatory (always selected) column for ID

Hi ASMParDA,
Thanks for your detailed explanation and examples and it really helped in reproducing the scenario.

I’ve implemented your requirement in Power BI using field parameters and a custom DAX measure to conditionally show rows based on whether the selected columns contain non-blank values for each Unique ID. The Unique ID column remains fixed in the visual, and only rows with at least one non-blank value in the selected fields are displayed.

Example Outcomes (as requested):

• If the user selects order quantity and delivered quantity, rows with non-blank values in either of those are shown.

• If the user selects sales volume and sales value, only rows with data in those fields are shown.

For your reference, I’m attaching the working .pbix file so you can explore the implementation directly.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.