Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Flitering

Hi    Is it possible to write a measure that will return the a list of the highlighted item?       
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, Anonymous 

     

    It may not be easy to get the desired result using the average function, but other functions can be used to achieve the purpose, such as 

    average =DIVIDE ( SUM ( 'table'[Score] ), 9 )

    OR:  average =DIVIDE ( SUM ( 'table'[Score] ), COUNTROWS ( 'table' ) + 1 ).

     

     

    Is this the result you want? Hope this is useful to you

    Please feel free to let me know If you have further questions

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , You can create a measure like

Countrows(filter(Table, Table[Name] in {"Process Audit Sweing 2", "Process Audit Loading & Swing" , "rocess Audit Foundation", "rocess Audit Unit Building"))

 

You can plot this with name in visual, if needed

Anonymous's avatar
Anonymous
Not applicable
5 years ago

This is what I got, I wanted to have seleted items in list, if I were to put them in a table.