Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Using a measure in a calculated column

Hi Everyonne,  It's my first time using the platform please be gentle 🙂   I need some help using a measures in a calculated column.   I have 2 measures that calculate the average marks and stan...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello Anonymous ,

 

Welcome to community.

 

Rather than creating a new column for Standard score, you can still create it as a DAX measure and use it anywhere in table or whereever you want. If you do like that whatever filter you apply dynamically the column also gets calculated automatically.

 

Let me know if I didn't understood your question properly.

 

Thanks,

Karthik

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Karthik, 

    Thanks for your response. 

     

    I need to standard score per student based on the grade, subject... If I do this as a measure I need to aggreated this which doesn't work as desired

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This is the sample data and calculation in excel