How can a column row value be set from Field Parameter selections

[Db111]

We have a column that is used to filter the visual.

ShowRow = If('Combined Queries'[Bananas]<>1 || 'Combined Queries'[Apples]<>1 || 'Combined Queries'[Pears]<>1,"No","Yes")

We have now created a field parameter table and bound to a table visualisation.

Entity Selector = {

    ("Bananas", NAMEOF('Combined Queries'[Bananas]), 0),

    ("Apples", NAMEOF('Combined Queries'[Apples]), 1),

    ("Pears", NAMEOF('Combined Queries'[Pears]), 2)

}

We now want to update the ShowRow formulae based on the selections of 'Entity Selector' e.g. if bananas and pears are selected we don't want ShowRow to use the Apples value to set it's value.

Thanks

[Anonymous · Accepted solution]

Hi @Db111 ,

How about change the ShowRow to a measure.

Create a measure.

ShowRow = If(max('Combined Queries'[Bananas])<>1 || max('Combined Queries'[Apples])<>1 || max(
'Combined Queries'[Pears])<>1,"No","Yes")

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.