Forum Discussion
Joining multiple formulas into one
Variables are an efficient way of getting what you need.
I believe it may be but I believe my problem is slightly more complex than that.. so the one % is only one of many. Let me pose another question in a new dicussion. I appreciate your help and the var worked. However, I really want those results set at a different level. I have attached a cloud based PBIX file for your review. In the screenshot below I have created a metric score 1; however, I need that calculation for about 13 other metrics. Is there an easy way to do this? So I would want to use the score guide table to build a relationship between the metrics 1-13 and then I want the scores to show up across the entire data set. So essentially I want Metric 1 Scores, Metric 2 Scores, Metric 3 scores, etc.. and then the 0-10 scoring graph on there one single time for all the scores as they have the same calculations just under different metrics. Any insight would be amazing. I have created dummy data to get assistacne with the report.
https://drive.google.com/open?id=1mSopjlD9DtDh_sscTAHXXIDkEj5bpxvE
Hi nmck86,
Sorry but cannot access your shared link. It says access denied. Please make a check.
Thanks,
Xi Jin.- v-xjiin-msft try the below link! Sorry about that.
https://drive.google.com/open?id=1mSopjlD9DtDh_sscTAHXXIDkEj5bpxvECan you pivot the Metric fields.
You can then have a calculate the same expression grouped by different attribute/metrics
You can add an index or create a calculated key of Store and Date to join to a master table.
http://radacad.com/pivot-and-unpivot-with-power-bi
