Forum Discussion

Mungai's avatar
Mungai
New Member
3 years ago
Solved

Filtering columns

Hi I need to select all the product items with sale values greater than 100000. then need to show this info in a table, that is, the product item and sale value.  
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Mungai ,

    Please have a try.

    Create a measure.

     

    measure =
IF (
    distinct ( table[sales values] ) >= 100000,
    MAX ( table[sales values] ),
    BLANK ()
)

     

    Then filter the measure is not blank.

     

    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 Mungai ,

Please have a try.

Create a measure.

 

measure =
IF (
    distinct ( table[sales values] ) >= 100000,
    MAX ( table[sales values] ),
    BLANK ()
)

 

Then filter the measure is not blank.

 

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.