Forum Discussion
Solved
Measure to select rows based on dynamic conditions
Hi, I'm relatively new to PowerBI so I have been searching for so many ways to do this but none of them seem to fit. I would like to find a way using a measure to select rows based on a condition, ...
Hi honkiedonkie ,
Please refer to my pbix file.
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ThxAlot
Super User
Super User
This is genius, thank you for this!
Just one more thing - is there a way for me to do the same but filter using a measure rather than a column?
Say, if the dataset has multiple rows where Category and Week is the same, and I have a measure that takes the average of all rows with the same Category-Week. Putting FILTER(INFO, [Averaging Measure] < MAX(Threshold[Value])) doesn't seem to work.
Again, thank you so much!