topic Re: Flitering in Desktop

Flitering

Anonymous — Tue, 27 Apr 2021 19:04:35 GMT

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

Re: Flitering

amitchandak — Wed, 28 Apr 2021 02:38:00 GMT

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

Re: Flitering

Anonymous — Wed, 28 Apr 2021 12:38:40 GMT

I got this

Re: Flitering

Anonymous — Wed, 28 Apr 2021 12:47:17 GMT

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

Re: Flitering

v-angzheng-msft — Fri, 30 Apr 2021 04:16:08 GMT

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.

Re: Flitering

Anonymous — Wed, 05 May 2021 14:38:04 GMT

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

Re: Flitering

v-angzheng-msft — Thu, 06 May 2021 01:30:12 GMT

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.

Re: Flitering

Anonymous — Wed, 19 May 2021 13:15:23 GMT

I tried both and they didnt work.

thanks

John