Report Portal

Arbitrary combination of measures and calculation items

The consumption experience following the introduction of calculation groups needs to be improved in Power BI. For example, the immediate advantage of having a time intelligence calculation group is that it is no longer necessary to create multiple variations of the same measure to implement all the possible time intelligence calculations. However, what happens when you have a matrix with Sales Amount, Total Cost, Margin, but you want to show the current value for all the measures and the year-over-year difference only for the Margin measure? Today, if you add a year-over-year calculation item to the matrix, you get the year-over-year of all the measures. We would like to get rid of the columns highlighted in red in the following screenshot.

Read more...

 

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.