Hello,
I am pretty new to PowerBI and have been working on making a report in Desktop with the SQL Azure data that I am connecting to via DirectQuery. In this report, I calculate a particular measure, and I calculate it for several of the columns in the database table I am querying. This measure is a percentage out of the total number of rows in the table and I then display it with the card visualization separately for each column.
What I am having trouble with now is that I also need to be able to do some calculations over all of these separate measures. For instance, I want the median of all of the measures. However, it doesn't seem like that is possible using DAX, as DAX only lets you take the median of an entire column. Is there some way that I could put all my measures into a column in a table and then do the median that way, or is there just no way to do what I am looking to accomplish? For right now I am using the average and calculating it manually (summing all the measures and dividing by how many there are) but we also want to have the median and possibly even percentiles of values across all the measures.
Thanks for any help you can give in advance!
