topic Re: How can a column row value be set from Field Parameter selections in DAX Commands and Tips

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

Db111 — Wed, 07 Dec 2022 15:18:36 GMT

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

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

Anonymous — Thu, 08 Dec 2022 02:58:16 GMT

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.