Forum Discussion

anwarbi's avatar
anwarbi
Icon for Helper III rankHelper III
4 years ago
Solved

Adding a Filter in a measure

Hi,
 
In the below measure, I am trying to add a count of response filter which s. The filter should be applied on Companies.
Distinctcount('Master)'[name])>10
 
Average = CALCULATE(AVERAGEX(VALUES(Companies[Companies]),CALCULATE(AVERAGE('Master)'[weight]),'Master'[retalted companies]<>"")),ALL('Master)'[Companies]))
 
Appreciate your help.
 
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi anwarbi ,

     

    Please try this:

    Average =
CALCULATE (
    AVERAGEX (
        FILTER (
            SUMMARIZE (
                FILTER ( 'Master', 'Master'[retalted companies] <> "" ),
                Companies[Companies],
                "more filter", DISTINCTCOUNT ( 'Master'[name] ),
                "average", AVERAGE ( 'Master'[weight] )
            ),
            [more filter] > 10
        ),
        [average]
    ),
    ALL ( 'Master)'[Companies] )
)

     

    If you need more help, please share some example data and expect result.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi anwarbi ,

     

    Please try this:

    Average =
CALCULATE (
    AVERAGEX (
        FILTER (
            SUMMARIZE (
                FILTER ( 'Master', 'Master'[retalted companies] <> "" ),
                Companies[Companies],
                "more filter", DISTINCTCOUNT ( 'Master'[name] ),
                "average", AVERAGE ( 'Master'[weight] )
            ),
            [more filter] > 10
        ),
        [average]
    ),
    ALL ( 'Master)'[Companies] )
)

     

    If you need more help, please share some example data and expect result.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.