Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

filter column

Dear community,  I calculate average per row via below formula,  MeasureAvgY = CALCULATE(AVERAGE('wash'[Y]), ALLEXCEPT('Table', 'Table'[C], 'Table'[S], 'Table'[L])) now it shows average value per...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hello, @Helia9235

    According to your description, I created data to reproduce your scenario. The pbix file is attached at the end.

    Mesa:

    b1.png

    You can create a measure as follows.

    Result = 
IF(
    ISINSCOPE('Table'[Category]),
    SUM('Table'[Y]),
    CALCULATE(
        AVERAGE('Table'[Y]),
        ALLEXCEPT('Table','Table'[Cluster],'Table'[Stain],'Table'[Determination Label])
    )
)

    Result:

    b2.pngb3.png

    Best regards

    Allan

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

v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

Hello, @Helia9235

According to your description, I created data to reproduce your scenario. The pbix file is attached at the end.

Mesa:

b1.png

You can create a measure as follows.

Result = 
IF(
    ISINSCOPE('Table'[Category]),
    SUM('Table'[Y]),
    CALCULATE(
        AVERAGE('Table'[Y]),
        ALLEXCEPT('Table','Table'[Cluster],'Table'[Stain],'Table'[Determination Label])
    )
)

Result:

b2.pngb3.png

Best regards

Allan

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for your help v-alq-msft , I have a another question, in this measure which you provided how can I also add STDV function? 

    STDEV.S('Table'[Y])

    I tried to add it next to AVERAGE but does not work.