Forum Discussion

Otrova's avatar
Otrova
New Member
3 years ago
Solved

Filtering rows in a matrix by using a Measure and a visual filter

Hello Power Bi community.    I'm currently exploring PBI, and its amazing capabilities.    I did a bit of research and Im able to filter row sin a 'TABLE visual' by using a slicer, a measure and ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 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 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

foodd's avatar
foodd
Community Champion
3 years ago

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.