Forum Discussion
Transposing measures
Hi, Anonymous
The measure value is based on calculation. When there is no context, the measure value will calculate the total value. You cannot get a single value without the context of the table.Also in the video, the three measures are also the total value of the three colors.
The transposition described in the video actually uses some functions to imitate the effect of transposition, and all parameters are hard-coded.
If you want to create a single subject score for a single student, you need to add more filter conditions to the measurement value, for example: measure= calculate(sum[marks], student="john", subject ="math").This means that you may need to establish separate measure for each student's mark in each subject.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
The measure value is based on calculation. When there is no context, the measure value will calculate the total value. You cannot get a single value without the context of the table.Also in the video, the three measures are also the total value of the three colors.
The transposition described in the video actually uses some functions to imitate the effect of transposition, and all parameters are hard-coded.
If you want to create a single subject score for a single student, you need to add more filter conditions to the measurement value, for example: measure= calculate(sum[marks], student="john", subject ="math").
This means that you may need to establish separate measure for each student's mark in each subject.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.