Forum Discussion
Solved
Measure inside Matrix to calculate de diference
Hi guys! I am doing a matrix with two versions and I need to calculate the diference between the second and the first. The values are in the same column and I am using the same measure to calculate...
You are using Versao in the column of the matrix. Remove that and do this:
Create this measures:Total Ton R&O =
calculate( SUM('fPlanoVendas'[Tonelada]), 'fPlanoVendas'[Version] = "2022 Rev.1 - R&O")Total Ton Verdas =
calculate( SUM('fPlanoVendas'[Tonelada]), 'fPlanoVendas'[Version] = "2022 Rev.2 - Vendas")Diff = [Total Ton R&O] - [Total Ton Verdas]
Use all 3 measures in the matrix ( and dont forget to remove Versao from the column matrix)
Total TON = SUM('fPlanoVendas'[Tonelada])
I use the same measure for both.
I use the same measure for both.