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 create...
  • 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.

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.