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

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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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.


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