Forum Discussion
Filtering rows in a matrix by using a Measure and a visual filter
- Anonymous3 years ago
Hi Otrova ,
Instead of using visual filters, consider use this measure directly.
Count_Filter = VAR MinValue = MIN('Count'[Count_No]) VAR MaxValue = MAX('Count'[Count_No]) VAR CurrentCountValue = [Count of Cycle_Count] RETURN IF( CurrentCountValue >= MinValue && CurrentCountValue <= MaxValue,[Count of Cycle_Count])output.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi Otrova ,
Instead of using visual filters, consider use this measure directly.
Count_Filter =
VAR MinValue = MIN('Count'[Count_No])
VAR MaxValue = MAX('Count'[Count_No])
VAR CurrentCountValue = [Count of Cycle_Count]
RETURN
IF( CurrentCountValue >= MinValue && CurrentCountValue <= MaxValue,[Count of Cycle_Count])
output.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum