Forum Discussion

Regular Visitor

4 years ago

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 the total.

Is it possible to create a dinamic measure to calculate this?

I can change the versions, but always keeping two versions to compare the diference between it.

The choose will be from data segmentation or filter.

Thanks a lot for help!!!

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)

Tutu_in_YYC
Super User
4 years ago
Can you provide the DAX measures for those 2? R&o and Vendas?
amitchandak
Super User
4 years ago
MatSantos , You need to create a measure like

calculate( SUM('fPlanoVendas'[Tonelada]), filter('fPlanoVendas', 'fPlanoVendas'[Version] = "2022 Rev.1 R&O")) -calculate( SUM('fPlanoVendas'[Tonelada]), filter('fPlanoVendas', 'fPlanoVendas'[Version] = "2021 Rev.1 R&O"))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- MatSantos
  Regular Visitor
  4 years ago
  Hi,
  The mesure worked in the card, but when I put in the matrix shows other value and duplicate the column.
  - Tutu_in_YYC
    Super User
    4 years ago
    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)
MatSantos
Regular Visitor
4 years ago
Total TON = SUM('fPlanoVendas'[Tonelada])
I use the same measure for both.