I have a table that has a Metric Name column that consists multiple metrics and a Metric Value column. I want to calculate the z score for the data within each of the AAA, BBB, and CCC metric. As I actually have hundreds of metric to deal with in reality, I wonder if I can calculate the z score in one single column and then use a filter to look at one single metric when I built the dashboard? Or is there a better way to do it in Power BI? I guess I could also pivot the table to get three seperate columns for AAA, BBB, and CCC, but then I'll have to write the same formula three times, too tedious. Any advice? Thanks.