filter column

[Anonymous]

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 column, 
How can I have just 1 column per row? I want to show average of each row in just one column at the end.
Thanks in advanc

[v-alq-msft · Accepted solution]

Hello, @Helia9235

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

Mesa:

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:

Best regards

Allan

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

[Anonymous]

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.

[amitchandak]

@Anonymous ,  The information you have provided is not making the problem clear to me. Can you please explain with an example?

If you are using a matrix, remove columns from "Column"

Appreciate your Kudos.