Forum Discussion

Db111's avatar
Db111
Frequent Visitor
3 years ago
Solved

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

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's avatar
    Anonymous
    3 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.