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? 

 

 

 

  • 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.

7 Replies

  • 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

      I got this 

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable

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

       

       

       

  •  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's avatar
      Anonymous
      Not applicable

      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's avatar
        v-angzheng-msft
        Community Support

        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.