Flitering

[Anonymous]

Hi 

Is it possible to write a measure that will return the a list of the highlighted item? 

[v-angzheng-msft]

 Hi, @Anonymous 

Try to create a calculate column like below:

Return =
IF (
    'Table'[name]
        IN {
        { "Sewing1" },
        { "Sewing3" },
        { "Receiving" },
        { "Quilting" },
        { "Matt Build" }
    },
    'Table'[name],
    BLANK ()
)

Note that to replace the text above with your actual text

I created a simple sample to illustrate this.

Sample:

Use the slicer to filter out null values.

Result:

Please refer to the attachment below for details

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.

[Anonymous]

I want to know if its possible to overwrite the denominator when using average in Power BI. what I mean is in the table listed below I want the average of the 8 process but I want to divide by 9 instead of 8. is that possible

[v-angzheng-msft · Accepted solution]

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.

[Anonymous]

HI 

I tried both and they didnt work.

thanks 

John

[amitchandak]

@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]

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

[Anonymous]

I got this