1 of 1 people found this helpful
What are you calculating the percentage difference based on? You could make one worksheet with the normal sum values, then another worksheet with the % difference and bring it together in a dashboard.
Can you share a sample data set and what you are expecting to show on the view.
It will be easier to build an example for you if we can look at a sample data
Are you looking for something like this? If so, then you can filter on Measure Names and Select "Quantity" and "Sales". This will add SUM(Quantity) and SUM(Sales) to the Measure Values card. Change each of these to table calcs using the Quick Table Calculation option. Then drag Quantity and Sales to the Measure Values card again to create new measures for the totals. See attached workbook.
Multiple Measures.twbx 1.2 MB